[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