Re: Abnormal storage consumption with autovacuum enabled

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Abnormal storage consumption with autovacuum enabled
Дата
Msg-id 6032.1180024806@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Abnormal storage consumption with autovacuum enabled  (Nicola Mauri <nicola.mauri@saga.it>)
Список pgsql-admin
Nicola Mauri <nicola.mauri@saga.it> writes:
> Data stored in the database didn't groove very much in the last months
> (pg_dump still generates a 4GB compressed file), but data files now
> occupies 20 GB on disk.
> I know that a vacuum full or a full dump/restore is needed to reclaim
> filesystem space. However, my question is: how this could have been
> happened?

What do you have max_fsm_pages set to?  If it's too small, you'll get
bloat regardless of whether autovac is doing its thing.

            regards, tom lane

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

Предыдущее
От: Emma H.G.
Дата:
Сообщение: Developer help
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Role based database access