On 08/30/2012 03:52 AM, Khangelani Gama wrote:
Hi
I need help in turning off autovacuum in the Database that’s running
postgres 9.1.2 DB. I tried to turn it off by putting “off” in
postgresql.cont file and restarted the postmaster but when I run “*show
autovacuum;* “ query I still see autovacuum set on inside the database.
autovacuum
------------
on
In addition to what has already been said, it is important to note that
changing the setting to off does not entirely turn off autovacuum.
http://www.postgresql.org/docs/9.1/interactive/runtime-config-autovacuum.html
"Note that even when this parameter is disabled, the system will launch
autovacuum processes if necessary to prevent transaction ID wraparound.
See Section 23.1.4 for more information."
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
