Tue Aug 9 15:40:17 PDT 2005
- Previous message: [Slony1-general] slony vacuuming
- Next message: [Slony1-general] query too complex after subscribing a set with big tables at busy time
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Oezcan Acar wrote: >Hi, >how can I prevent slony to vacuum the slave database after replicating? We >are running a heavy loaded webapp and any vacuum under this load seems to >block the whole database. > > 1. Look at the documentation for slon, paying particular attention to the "-c" option 2. If you configure slon to NOT vacuum its tables, then you had better have your own regular regimen that vacuums them, otherwise you'll find that replication performance will get very bad. In other words, if you stop slon from vacuuming, it is pretty easy for performance to get worse. 3. If your system is so overloaded that vacuuming the (usually fairly small) Slony-I tables appears to "block the whole database," then you have some bad performance problems, and should look into the cause, which certainly isn't the vacuuming of Slony-I tables. VACUUM ANALYZE is a non-blocking operation, after all.
- Previous message: [Slony1-general] slony vacuuming
- Next message: [Slony1-general] query too complex after subscribing a set with big tables at busy time
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list