Re: database size growing continously

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: database size growing continously
Дата
Msg-id alpine.DEB.2.00.0910291558320.19472@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: database size growing continously  (Josh Rovero <rovero@sonalysts.com>)
Список pgsql-performance
On Thu, 29 Oct 2009, Josh Rovero wrote:
> Do you ever "vacuum full" to reclaim empty record space?

Unless you expect the size of the database to permanently decrease by a
significant amount, that is a waste of time, and may cause bloat in
indexes. In this case, since the space will be used again fairly soon, it
is better to just VACUUM, or autovacuum. Just make sure the free space map
can cope with it.

Matthew

--
 import oz.wizards.Magic;
   if (Magic.guessRight())...           -- Computer Science Lecturer

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

Предыдущее
От: Josh Rovero
Дата:
Сообщение: Re: database size growing continously
Следующее
От: Ludwik Dylag
Дата:
Сообщение: Re: database size growing continously