| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | Prabhjot Sheena <prabhjot(dot)sheena(at)rivalwatch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: system catalog to check if auto vacuum is disabled for a particular table |
| Date: | 2013-08-08 19:18:21 |
| Message-ID: | A76B25F2823E954C9E45E32FA49D70EC1BBF4129@mail.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Prabhjot Sheena
Sent: Thursday, August 08, 2013 2:36 PM
To: pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Seref Arikan | 2013-08-08 19:30:39 | Re: Pl/Python runtime overhead |
| Previous Message | Prabhjot Sheena | 2013-08-08 18:36:24 | system catalog to check if auto vacuum is disabled for a particular table |