Re: Check table storage parameters

Поиск
Список
Период
Сортировка
От Lee Hachadoorian
Тема Re: Check table storage parameters
Дата
Msg-id CANnCtnKP+-iobFBzQfHjG0S4+zu2LYfifcL6xusuZAbftjLo7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Check table storage parameters  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-general
> 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 по дате отправления:

Предыдущее
От: Nicolas Grilly
Дата:
Сообщение: Re: Full text search ranking: ordering using index and proximiti ranking with OR queries
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: High SYS CPU - need advise