Thread: autovacuum daemon
Deal All,
I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not.
Regards,
Avdul Rehman.
I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not.
Regards,
Avdul Rehman.
Abdul Rahman wrote: > Deal All, > > I have set postgresql.conf for autovacuum and need to know weather the > process is running/working or not. Run this query: SHOW autovacuum; If it says "on", then it is working. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alvaro Herrera schrieb: > Abdul Rahman wrote: >> Deal All, >> >> I have set postgresql.conf for autovacuum and need to know weather the >> process is running/working or not. > > Run this query: > SHOW autovacuum; way easiere than my approach ;-) Thanks! Andy - -- St.Pauli - Hamburg - Germany Andreas Wenk > > If it says "on", then it is working. > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJd0CPVa7znmSP9AwRAq0bAKDUENJo040IJDoDfEUKHUFMd61jqACg0X02 NljMvjCXVvNObOwFXlpVGbA= =ba05 -----END PGP SIGNATURE-----