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

wal_buffer tests in

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: wal_buffer tests in
Date: 2005-07-27 20:30:01
Message-ID: 200507271330.02083.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Responses

pgsql-performance by date

Next:From: Sebastian HennebruederDate: 2005-07-27 21:21:39
Subject: Re: Mirroring PostgreSQL database
Previous:From: Kris JurkaDate: 2005-07-27 18:28:44
Subject: Re: [Bizgres-general] Re: faster INSERT with possible

pgsql-hackers by date

Next:From: Dave PageDate: 2005-07-27 20:52:08
Subject: Re: --enable-thread-safety on Win32
Previous:From: Alvaro HerreraDate: 2005-07-27 20:26:14
Subject: Re: [HACKERS] Autovacuum loose ends

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