Postgres Pro
Downloads
Home   >   mailing lists

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

From Mike Blackwell
Subject Re: Check table storage parameters
Date
Msg-id CANPAkgttLF-B7TPNSDOqDvmTtfa14E3UGam+XeiME2VJ6-P_Pw@mail.gmail.com
Whole thread Raw
In response to Check table storage parameters  (Lee Hachadoorian <Lee.Hachadoorian+L@gmail.com>)
Responses Re: Check table storage parameters
List pgsql-general
Tree view
Try pg_class.reloptions?

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com





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.

Sorry to ask such basic question, but I can't find this in the docs,
and every search I've tried ends up taking me to how to *set* the
parameter with CREATE TABLE and ALTER TABLE.

Thanks,
--Lee

--
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Vlad
Date:
Subject: Re: High SYS CPU - need advise