Postgres Pro
Downloads
Home   >   mailing lists

Re: Check table storage parameters - Mailing list pgsql-general

From Lee Hachadoorian
Subject Re: Check table storage parameters
Date
Msg-id CANnCtnKP+-iobFBzQfHjG0S4+zu2LYfifcL6xusuZAbftjLo7Q@mail.gmail.com
Whole thread Raw
In response to Re: Check table storage parameters  (Mike Blackwell <mike.blackwell@rrd.com>)
List pgsql-general
Tree view 
> On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian
> <Lee.Hachadoorian+L@gmail.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.blackwell@rrd.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/

pgsql-general by date:

Previous
From: Nicolas Grilly
Date:
Subject: Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Next
From: Jeff Janes
Date:
Subject: Re: High SYS CPU - need advise