free space map

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема free space map
Дата
Msg-id 1d219a6f0606200744y40714eb5sec53ed5aba3693cc@mail.gmail.com
обсуждение исходный текст
Ответы Re: free space map  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
Is there anyway to query the free space map and see  how many entries there are for a specific table? 

We are starting to have some performance issues since our upgrade to 8.1 (running 8.1.3).  However I can vacuum one table and the issues are temporarily solved.  I am trying to do some research and would like to know what the fsm looks like before and after I vacuum this table.

Is this possible?

Thanks,

Chris
RH 4
PG 8.1.3

В списке pgsql-admin по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Unique constraint and index-combination feature in 8.1
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: free space map