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

Re: wal_buffer tests in

From: Mark Wong <markw(at)osdl(dot)org>
To: josh(at)agliodbs(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: wal_buffer tests in
Date: 2005-07-27 21:42:01
Message-ID: 200507272141.j6RLfNjA026772@smtp.osdl.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
On Wed, 27 Jul 2005 13:30:01 -0700
Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> Folks,
> 
> I ran a wal_buffer test series.   It appears that increasing the 
> wal_buffers is indeed very important for OLTP applications, potentially 
> resulting in as much as a 15% average increase in transaction processing.  
> What's interesting is that this is not just true for 8.1, it's true for 
> 8.0.3 as well.   
> 
> More importantly, 8.1 performance is somehow back up to above-8.0 levels.  
> Something was broken in June that's got fixed (this test series is based 
> on July 3 CVS) but I don't know what.  Clues?
> 
> Test results are here:
> http://pgfoundry.org/docman/view.php/1000041/79/wal_buffer_test.pdf
> 
> As always, detailed test results are available from OSDL, just use:
> http://khack.osdl.org/stp/#
> where # is the test number.

The increase could actually be higher than 15% as 1800 notpm is about
the max throughput you can have with 150 warehouses with the default
thinktimes.  The rule of thumb is about 12 * warehouses, for the
throughput.

Mark

In response to

pgsql-performance by date

Next:From: PFCDate: 2005-07-27 21:53:02
Subject: Re: [Bizgres-general] Re: faster INSERT with possible
Previous:From: Simon RiggsDate: 2005-07-27 21:37:47
Subject: Re: [Bizgres-general] Re: faster INSERT with possible

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2005-07-27 21:54:26
Subject: Re: Integrated autovacuum
Previous:From: Martín MarquésDate: 2005-07-27 21:35:31
Subject: Re: Integrated autovacuum

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