| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2005-07-27 20:52:08 | Re: --enable-thread-safety on Win32 |
| Previous Message | Alvaro Herrera | 2005-07-27 20:26:14 | Re: [HACKERS] Autovacuum loose ends |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastian Hennebrueder | 2005-07-27 21:21:39 | Re: Mirroring PostgreSQL database |
| Previous Message | Kris Jurka | 2005-07-27 18:28:44 | Re: [Bizgres-general] Re: faster INSERT with possible |