Re: About the relation between fragmentation of file and

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: About the relation between fragmentation of file and
Дата
Msg-id 20051201120028.GA7330@mathom.us
обсуждение исходный текст
Ответ на About the relation between fragmentation of file and VACUUM  ("Tatsumi Abe" <sc-abe@milan.nri.co.jp>)
Список pgsql-performance
On Thu, Dec 01, 2005 at 02:50:56PM +0900, Tatsumi Abe wrote:
>Could anyone advise some solutions for this fragmentation problem
>without stopping PostgreSQL ?

Stop doing VACUUM FULL so often. If your table size is constant anyway
you're just wasting time by compacting the table and shrinking it, and
encouraging fragmentation as each table file grows then shrinks a little
bit each day.

Mike Stone

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

Предыдущее
От: "Franklin Haut"
Дата:
Сообщение: pg_dump slow
Следующее
От: Bill McGonigle
Дата:
Сообщение: Re: About the relation between fragmentation of file and VACUUM