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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-07-27 21:54:26 | Re: Integrated autovacuum |
Previous Message | Martín Marqués | 2005-07-27 21:35:31 | Re: Integrated autovacuum |
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2005-07-27 21:53:02 | Re: [Bizgres-general] Re: faster INSERT with possible |
Previous Message | Simon Riggs | 2005-07-27 21:37:47 | Re: [Bizgres-general] Re: faster INSERT with possible |