Skip site navigation (1) Skip section navigation (2)  Re:
Checkpoint sync pause  Subject: Re: Checkpoint sync pause Date:
2012-01-17 01:59:08 Message-ID: (view raw or flat) Lists: pgsql-
hackers On 01/16/2012 11:00 AM, Robert Haas wrote: > Also, I am
still struggling with what the right benchmarking  > methodology
even is to judge whether > any patch in this area "works".  Can
you provide more details about > your test setup?  The "test"
setup is a production server with a few hundred users at peak
workload, reading and writing to the database.  Each RAID
controller  (couple of them with their own tablespaces) has
either 512MG or 1GB of  battery-backed write cache.  The setup
that leads to the bad situation  happens like this:  -The steady
stream of backend writes that happen between checkpoints  have
filled up most of the OS write cache.  A look at /proc/meminfo
shows around 2.5GB "Dirty:"  -Since we have shared_buffers set
to 512MB to try and keep checkpoint  storms from being too bad,
there might be 300MB