Postgres Pro
Downloads
Home   >   mailing lists

Re: system catalog to check if auto vacuum is disabled for a particular table - Mailing list pgsql-general

From Igor Neyman
Subject Re: system catalog to check if auto vacuum is disabled for a particular table
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC1BBF4129@mail.corp.perceptron.com
Whole thread Raw
In response to system catalog to check if auto vacuum is disabled for a particular table  (Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Prabhjot Sheena
Date:
Subject: system catalog to check if auto vacuum is disabled for a particular table
Next
From: Seref Arikan
Date:
Subject: Re: Pl/Python runtime overhead