Re: max fsm pages question

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: max fsm pages question
Дата
Msg-id 362E0126-A054-4C70-B702-C467A1778D2E@khera.org
обсуждение исходный текст
Ответ на Re: max fsm pages question  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
On Jul 8, 2008, at 3:24 PM, Bill Moran wrote:

> If you don't handle this, that table will continue to grow in size on
> the disk, taking up space unnecessarily and probably negatively
> impacting performance.

s/probably/definitely/

Also, if it was #3 on Bill's list, one thing to do is look for index
bloat.  Reindex followed by vacuum might help as well.

As for running VACUUM FULL, I find it sometimes faster to just do a
dump + reload.  A FULL vacuum is really, really, really, extremely,
slow.


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

Предыдущее
От: "achill@matrix"
Дата:
Сообщение: Re: syslog performance when logging big statements
Следующее
От: Ow Mun Heng
Дата:
Сообщение: Altering a column type - Most efficient way