Re: Log levels for checkpoint/bgwriter monitoring - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Log levels for checkpoint/bgwriter monitoring
Date
Msg-id E440FC7A-8148-41FB-BF56-BB651603D4C1@decibel.org
Whole thread Raw
In response to Re: Log levels for checkpoint/bgwriter monitoring  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-hackers
On Mar 8, 2007, at 11:51 PM, Greg Smith wrote:
> almost everything that's dirty is also pinned during pgbench, and  
> the LRU is lucky to find anything it can write as a result

I'm wondering if pg_bench is a good test of this stuff. ISTM it's  
unrealistically write-heavy, which is going to tend to not only put a  
lot of dirty buffers into the pool, but also keep them pinned enough  
that you can't write them.

Perhaps you should either modify pg_bench to do a lot more selects  
out of the various tables
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Log levels for checkpoint/bgwriter monitoring
Next
From: Jim Nasby
Date:
Subject: Re: Log levels for checkpoint/bgwriter monitoring