Re: Configuring PostgreSQL to minimize impact of checkpoints

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Configuring PostgreSQL to minimize impact of checkpoints
Дата
Msg-id A50DAE0E-A44A-11D8-AA3E-000A9578CFCC@kcilink.com
обсуждение исходный текст
Ответ на Re: Configuring PostgreSQL to minimize impact of checkpoints  (jao@geophile.com)
Список pgsql-performance
Дерево обсуждения 
On May 12, 2004, at 3:22 PM, jao@geophile.com wrote:

>>
>> I don't see that.  But I also set checkpoint segments to about 50 on
>> my big server.
>
> But wouldn't that affect checkpoint frequency, not checkpoint cost

Seems reasonable.  I suppose checkpointing doesn't cost as much disk
I/O as vacuum does.  My checkpoints are also on a separate RAID volume
on a separate RAID channel, so perhaps that gives me extra bandwidth to
perform the checkpoints.

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

Предыдущее
От: jao@geophile.com
Дата:
Сообщение: Re: Configuring PostgreSQL to minimize impact of checkpoints
Следующее
От: Bjoern Metzdorf
Дата:
Сообщение: Quad processor options - summary