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

Поиск
Список
Период
Сортировка
От Jignesh K. Shah
Тема LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Дата
Msg-id 4739CA51.8060406@sun.com
обсуждение исходный текст
Ответы Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (Greg Smith <gsmith@gregsmith.com>)
Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-hackers
Дерево обсуждения 
Hello,

I am running tests with PG8.3b2 on Solaris 10 8/07 and I still see IO 
flood when checkpoint happens.
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.

Then I tried increasing checkpoint_completion_target=0.9 but still no 
spread of IO (checkpoint_timeout is set to default 5m)

What am I missing?

How does PostgreSQL determine the Load distribution?

Regards,
Jignesh

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: How to keep a table in memory?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unnecessary casts in pg_cast