Re: Bgwriter strategies

On Thu, 2007-07-05 at 21:50 +0100, Heikki Linnakangas wrote:

> All test runs were also patched to count the # of buffer allocations, 
> and # of buffer flushes performed by bgwriter and backends. Here's those 
> results (I hope the intendation gets through properly):
> 
>             imola-336    imola-337    imola-340
> writes by checkpoint      38302          30410          39529
> writes by bgwriter     350113        2205782        1418672
> writes by backends    1834333         265755         787633
> writes total        2222748        2501947        2245834
> allocations        2683170        2657896        2699974

These results may show that the minimum bgwriter_delay of 10ms may be
too large for the workloads: whatever the strategy used the bgwriter
spends too much time sleeping when it should be working.

--  Simon Riggs EnterpriseDB  http://www.enterprisedb.com