| Christopher Browne 2005-08-09, 8:26 pm |
| 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.
|