Re: Postgres Benchmark Results

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/