From: [email protected] [mailto:[email protected]] On Behalf Of Prabhjot Sheena Sent: Thursday, August 08, 2013 2:36 PM To: [email protected] Subject: [GENERAL] system catalog to check if auto vacuum is disabled for a particular table
Guys i am using postgresql 9.2. How can i check if a particular table has auto vacuum disabled manually or not. Which system catalog can get me this information? Thanks ------------------------------------------------ You can query reloptions (it has type of text[]) in pg_class for your relname. If autovacuum was disabled one of the elements of the array will be: 'autovacuum_enabled=false'. Regards, Igor Neyman -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
