Re: Load distributed checkpoint

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Load distributed checkpoint
Дата
Msg-id 45795AD1.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Load distributed checkpoint  (Brad Nicholson <bnichols@ca.afilias.info>)
Ответы Re: Load distributed checkpoint  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-hackers

>>> On Fri, Dec 8, 2006 at 12:18 PM, in message
<1165601938.10248.56.camel@dba5.int.libertyrms.com>, Brad Nicholson
<bnichols@ca.afilias.info> wrote: 
> 
> How much increased I/O usage have you seen in regular operation with
> those settings?

We have not experience any increase in I/O, just a smoothing.  Keep in
mind that the file system cache will collapse repeated writes to the
same location until things settle, and the controller's cache also has a
chance of doing so.  If we just push dirty pages out to the OS as soon
as possible, and let the file system do its job, I think we're in better
shape than if we try to micro-manage it within our buffer pages.
You mileage may vary of course, but I'm curious whether any real world
production examples exist where this approach is a loser.
-Kevin



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

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: Load distributed checkpoint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Configuring BLCKSZ and XLOGSEGSZ (in 8.3)