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
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 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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general