Re: How to avoid database bloat

Поиск
Список
Период
Сортировка
От matthew@tocr.com
Тема Re: How to avoid database bloat
Дата
Msg-id 31520.68.175.84.212.1117769898.squirrel@mail.tocr.com
обсуждение исходный текст
Ответ на Re: How to avoid database bloat  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
> "Mindaugas Riauba" <mind@bi.lt> writes:
>>   And what in vacuum verbose output suggests that vacuum is not done
>> often enough? Current output (table is 100MB already) is below.
>
> The output shows vacuum cleaning up about a third of the table.  Usually
> people like to keep the overhead down to 10% or so ...


He was running with -V 0.5 which should transalate to roughly 50% of the
table being touched before a vacuum is issued.j

Matt

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

Предыдущее
От: Bahadur Singh
Дата:
Сообщение: Re: BUG #1697: Select getting slower on continously updating data
Следующее
От: K C Lau
Дата:
Сообщение: SELECT DISTINCT Performance Issue