Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Дата
Msg-id Pine.GSO.4.64.0711131414230.15021@westnet.com
обсуждение исходный текст
Ответ на LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Список pgsql-hackers
On Tue, 13 Nov 2007, Jignesh K. Shah wrote:

> I have tried increasing the bg_lru_multiplier from 2 to 5 from default but I 
> dont see any more writes by bgwriter happening than my previous test which 
> used the default.

The multiplier only impacts writes being done by the LRU eviction 
mechanism; it doesn't change anything related to the checkpoint writes. 
In fact, since those LRU writes are going on at the same time as the 
checkpoint ones, increasing the multiplier too much can make the 
checkpoint I/O spike worse.  It's unlikely that higher values will 
decrease the spike.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: How to keep a table in memory?
Следующее
От: Greg Smith
Дата:
Сообщение: Re: How to keep a table in memory?