From: Zoltan Boszormenyi <zb@cybertec.at>
To: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Benchmark Results
Date: Sun, 20 May 2007 20:00:25 +0200
Message-ID: <46508CB9.1040404@cybertec.at> (raw)
In-Reply-To: <op.tsmrv71ecigqcu@apollo13>
References: <op.tsmrv71ecigqcu@apollo13>
PFC írta:
>
> I felt the world needed a new benchmark ;)
> So : Forum style benchmark with simulation of many users posting
> and viewing forums and topics on a PHP website.
>
> http://home.peufeu.com/ftsbench/forum1.png
>
> One of those curves is "a very popular open-source database which
> claims to offer unparallelled speed".
> The other one is of course Postgres 8.2.3 which by popular belief
> is "full-featured but slow"
>
> What is your guess ?
Red is PostgreSQL.
The advertised "unparallelled speed" must surely mean
benchmarking only single-client access on the noname DB. ;-)
I also went into benchmarking mode last night for my own
amusement when I read on the linux-kernel ML that
NCQ support for nForce5 chips was released.
I tried current PostgreSQL 8.3devel CVS.
pgbench over local TCP connection with
25 clients and 3000 transacts/client gave me
around 445 tps before applying NCQ support.
680 tps after.
It went over 840 tps after adding HOT v7 patch,
still with 25 clients. It topped at 1062 tps with 3-4 clients.
I used a single Seagate 320GB SATA2 drive
for the test, which only has less than 40GB free.
So it's already at the end of the disk giving smaller
transfer rates then at the beginning. Filesystem is ext3.
Dual core Athlon64 X2 4200 in 64-bit mode.
I have never seen such a performance before
on a desktop machine.
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: zb@cybertec.at, lists@peufeu.com
Subject: Re: Postgres Benchmark Results
In-Reply-To: <46508CB9.1040404@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox