Skip site navigation (1) Skip section navigation (2)

Re: wal_buffer tests in

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: wal_buffer tests in
Date: 2005-07-28 21:57:10
Message-ID: 200507281457.10637.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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

In response to

pgsql-performance by date

Next:From: Karim NassarDate: 2005-07-28 23:04:25
Subject: Two queries are better than one?
Previous:From: Luke LonerganDate: 2005-07-28 18:27:36
Subject: Re: Finding bottleneck

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-07-28 22:14:03
Subject: Re: psql tab-completion for COMMIT/ROLLBACK PREPARED
Previous:From: Tom LaneDate: 2005-07-28 20:41:27
Subject: Re: Interesting COPY edge case...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group