| From: | Lee Hachadoorian <Lee(dot)Hachadoorian+L(at)gmail(dot)com> |
|---|---|
| To: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Check table storage parameters |
| Date: | 2012-11-16 18:07:31 |
| Message-ID: | CANnCtnKP+-iobFBzQfHjG0S4+zu2LYfifcL6xusuZAbftjLo7Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian
> <Lee(dot)Hachadoorian+L(at)gmail(dot)com> wrote:
>>
>> How can I read the current storage parameters for an existing table?
>> Specifically interested in autovacuum_enabled.
On Fri, Nov 16, 2012 at 12:08 PM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> wrote:
> Try pg_class.reloptions?
That was it.
Interestingly, if the table uses the server default, reloptions is NULL.
Best,
--Lee
--
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2012-11-16 18:26:43 | Re: High SYS CPU - need advise |
| Previous Message | Merlin Moncure | 2012-11-16 17:39:10 | Re: High SYS CPU - need advise |