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

From: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
To: pgsql-hackers(at)postgresql(dot)org
Subject: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Date: 2007-11-13 16:01:21
Message-ID: 4739CA51.8060406@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-13 16:31:18 Re: Unnecessary casts in pg_cast
Previous Message Andrew Sullivan 2007-11-13 15:07:47 Re: How to keep a table in memory?