Re: vacuum and 24/7 uptime

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: vacuum and 24/7 uptime
Дата
Msg-id 3B4E17D7.1E94CAB5@selectacast.net
обсуждение исходный текст
Ответ на vacuum and 24/7 uptime  (Mark <mark@ldssingles.com>)
Список pgsql-general
Philip Molter wrote:
>

> table).  We also recreate the indices on the most frequent table every
> 12 hours, since vacuum doesn't clean up after indices (again, it
> appears).
>
Are you sure about that?  Since an index grows with each insert or
update they would soon take up the whole disk for any active databases.

I see in my postgres log:
DEBUG:  Index ml_pkey: Pages 882; Tuples 174067: Deleted 18. CPU
0.07s/0.62u sec.



--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

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

Предыдущее
От: Somazx Interesting
Дата:
Сообщение: Re: compile error
Следующее
От: Ryan Mahoney
Дата:
Сообщение: Re: Visual Modeling programs