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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to