From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: [HACKERS] More benchmarking of wal_buffers |
Date: | 2003-02-13 06:17:52 |
Message-ID: | 1045117072.16760.7.camel@tokyo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
On Thu, 2003-02-13 at 00:16, Christopher Kings-Lynne wrote:
> Even if you look at the attached charts and you think that 128 buffers are
> better than 8, think again - there's nothing in it. Next time I run that
> benchmark it could be the same, lower or higher. And the difference between
> the worst and best results is less than 3 TPS - ie. nothing.
One could conclude that this a result of the irrelevancy of wal_buffers;
another possible conclusion is that the testing tool (pgbench) is not a
particularly good database benchmark, as it tends to be very difficult
to use it to reproduceable results. Alternatively, it's possible that
the limited set of test-cases you've used doesn't happen to include any
circumstances in which wal_buffers is useful.
We definitely need some better benchmarking tools for PostgreSQL (and
no, OSDB does not cut it, IMHO). I've been thinking of taking a look at
improving this, but I can't promise I'll get the time or inclination to
actually do anything about it :-)
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Kalchev | 2003-02-13 07:30:35 | Re: [HACKERS] Changing the default configuration |
Previous Message | Bruce Momjian | 2003-02-13 06:12:17 | Re: [HACKERS] Changing the default configuration (was Re: |
From | Date | Subject | |
---|---|---|---|
Next Message | mlw | 2003-02-13 06:31:47 | Re: location of the configuration files |
Previous Message | Peter Bierman | 2003-02-13 06:14:50 | Re: location of the configuration files |
From | Date | Subject | |
---|---|---|---|
Next Message | Darryl A. J. Staflund | 2003-02-13 08:32:44 | JBoss CMP Performance Problems with PostgreSQL 7.2.3 |
Previous Message | Bruce Momjian | 2003-02-13 06:12:17 | Re: [HACKERS] Changing the default configuration (was Re: |