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