[Pgpool-general] pgpool autovacuum sugestions

Armin Nesiren armin.nesiren at intera.si
Thu Sep 29 11:52:53 UTC 2011


Hello,


first, I'm sorry if it is already been asked, but I can not find it.

What is suggestion for vaccum or autovacuum for pgpool configurations.
I have pgpool configured for streaming replication.
Should I set autovacuum, or should I start autovacuum manually periodically?

I see that during online recovery, autovacuum should be disabled... but
thats for replication mode,
is it same for streaming replication?

Should autovacuum be launched through pgpool, or should I connect to
database directly?

This is normal when trying to start vacuum on slave node?

db1=> VACUUM FULL VERBOSE ANALYZE;
ERROR:  cannot execute VACUUM during recovery

-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110929/0accfb1a/attachment.html>


More information about the Pgpool-general mailing list