Re: Inserts or Updates

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Inserts or Updates
Дата
Msg-id CAGTBQpaR+_1MKOtSSSP+rg=OQLVHW26c1qSaVrvXpVR8TT4jGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
Ответы Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
Список pgsql-performance
On Tue, Feb 7, 2012 at 2:27 PM, Ofer Israeli <oferi@checkpoint.com> wrote:
> Thanks Kevin for the ideas.  Now that you have corrected our misconception regarding the autovacuum not handling
indexbloating, we are looking into running autovacuum frequently enough to make sure we don't have significant increase
intable size or index size.  We intend to keep our transactions short enough not to reach the situation where vacuum
fullor CLUSTER is needed. 

Also, rather than going overboard with autovacuum settings, do make it
more aggressive, but also set up a regular, manual vacuum of either
the whole database or whatever tables you need to vacuum at
known-low-load hours.

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

Предыдущее
От: Ofer Israeli
Дата:
Сообщение: Re: Inserts or Updates
Следующее
От: Ofer Israeli
Дата:
Сообщение: Re: Inserts or Updates