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)
Список
Дерево обсуждения
database size growing continously Peter Meszaros <pme@prolan.hu>
Re: database size growing continously Josh Rovero <rovero@sonalysts.com>
Re: database size growing continously Matthew Wakeling <matthew@flymine.org>
Re: database size growing continously Ludwik Dylag <ldylag@gmail.com>
Re: database size growing continously Ludwik Dylag <ldylag@gmail.com>
Re: database size growing continously "Joshua D. Drake" <jd@commandprompt.com>
Re: database size growing continously "Joshua D. Drake" <jd@commandprompt.com>
Re: database size growing continously Chris Ernst <cernst@esoft.com>
Re: database size growing continously Steve Crawford <scrawford@pinpointresearch.com>
Re: database size growing continously Steve Crawford <scrawford@pinpointresearch.com>
Re: database size growing continously Merlin Moncure <mmoncure@gmail.com>
Re: database size growing continously Jeremy Harris <jgh@wizmail.org>
Re: database size growing continously Anj Adu <fotographs@gmail.com>
Re: database size growing continously Greg Stark <gsstark@mit.edu>
Re: database size growing continously Jeremy Harris <jgh@wizmail.org>
Re: database size growing continously Greg Stark <gsstark@mit.edu>
Re: database size growing continously Anj Adu <fotographs@gmail.com>
Re: database size growing continously Scott Marlowe <scott.marlowe@gmail.com>
Re: database size growing continously Peter Meszaros <pme@prolan.hu>
Re: database size growing continously Robert Haas <robertmhaas@gmail.com>
Re: database size growing continously Anj Adu <fotographs@gmail.com> 
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
Дата:
Следующее
От: Ludwik Dylag
Дата:
FAQ