Re: wal_buffer tests in - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: wal_buffer tests in
Date
Msg-id 200507281457.10637.josh@agliodbs.com
Whole thread Raw
In response to Re: wal_buffer tests in  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg,

> You have wal_buffer set to 2048? That's pretty radical compared to the
> default of just 5. Your tests shows you had to go to this large a value
> to see the maximum effect?

No, take a look at the graph.   It looks like we got the maximum effect 
from a wal_buffers somewhere between 64 and 256.   On the DBT2 runs, any 
variation less than 5% is just noise.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some new list.c primitives
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [Testperf-general] dbt2 & opteron performance