Re: database size grows (even after vacuum (full and analyze))....

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: database size grows (even after vacuum (full and analyze))....
Дата
Msg-id 20060503144532.GC3774@wolff.to
обсуждение исходный текст
Ответ на database size grows (even after vacuum (full and analyze))....  (Joao Miguel Ferreira <jmf@estg.ipvc.pt>)
Ответы Re: database size grows (even after vacuum (full and analyze))....  (Joao Miguel Ferreira <jmf@estg.ipvc.pt>)
Список pgsql-novice
On Wed, May 03, 2006 at 12:02:18 +0100,
  Joao Miguel Ferreira <jmf@estg.ipvc.pt> wrote:
>
> My database gets about 30 INSERTs per minute, about 60 UPDATEs per
> minute and about 30 DELETEs per minute in a way that line counts tend to
> stabilize. The test is done in such a way that I can asure a constant
> average rate of INSERTs and the same average rate of DELETEs (after a
> certain life time for each record).
>
> Dispite this, the file system size still grows (at about 500KB in about
> 1000 minutes).

How often are you vacuuming the table?

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Tracking progress of (plpgsql?) operations
Следующее
От: Joao Miguel Ferreira
Дата:
Сообщение: Re: database size grows (even after vacuum (full and analyze))....