Postgres Pro
Downloads
Home   >   mailing lists

Thread: system catalog to check if auto vacuum is disabled for a particular table

system catalog to check if auto vacuum is disabled for a particular table

From
Prabhjot Sheena
Date:
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

Re: system catalog to check if auto vacuum is disabled for a particular table

From
Igor Neyman
Date:
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Prabhjot Sheena
Sent: Thursday, August 08, 2013 2:36 PM
To: pgsql-general@postgresql.org
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
systemcatalog 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