On Feb 17, 2010, at 6:23 PM, Greg Smith wrote:
JWith bgwriter_lru_maxpages=500 and bgwriter_delay=100ms, you can
get up to 5000 pages/second which makes for 300,000 pages/minute.
So none of your numbers look funny just via their scale. This is
why the defaults are so low--the maximum out
Jeff wrote:
while(true)
{
if buffers_written > bgwriter_lru_maxpages
or buffers_written > anticipated_pages_needed *
bgwriter_lru_multiplier
{
sleep(bgwriter_delay ms)
continue;
}
...
}
so I should not be able to have more than ~5000 bgwriter_clean pages
On Wed, 2010-02-17 at 08:30 -0500, Jeff wrote:
> Since getting on 8.4 I've been monitoring things fairly closely.
> I whipped up a quick script to monitor pg_stat_bgwriter and save
> deltas every minute so I can ensure my bgwriter is beating out the
> backends for writes (as it is supposed to d
