Re: Growing Database Size Solved

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Growing Database Size Solved
Дата
Msg-id 20030614134745.GF27374@wolff.to
обсуждение исходный текст
Ответ на Growing Database Size Solved  (Jason Godden <jasongodden@optushome.com.au>)
Ответы Re: Growing Database Size Solved  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sat, Jun 14, 2003 at 18:57:42 +1000,
  Jason Godden <jasongodden@optushome.com.au> wrote:
> My mistake - even though I was running VACUUM everyday I wasn't running VACUUM
> FULL - a VACUUM FULL fixed the problem.  Strange - I thought that regular
> VACUUM was pretty good these days?

You need to make sure that FSM is set high enough or that you vacuum
frequently enough that it will be big enough now that you have removed
most of dead tuples.

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Growing Database Size
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: Insert NULL for ''