PostgreSQL benchmarks

[Francois Tigeot]

Hi,

I have been running PostgreSQL benchmarks for the last few days.

The main idea was to test the scalability of DragonFly on many cores; for that
purpose I used a tool included with Postgres, Pgbench.

The server machine was a dual-Xeon system, with 12 cores, 24 hardware threads
and 96GB of memory.

The current development version of DragonFly was compared to the 2.10 one, as
well as with FreeBSD 9-RC1.
PostgreSQL-9.1 was used on all systems.

The tests made apparent some performance problems and some serious DragonFly
2.13 crashs which only manifested themselves on high loads. Thanks to Matthew
Dillon, they were fixed incredibly incredibly quickly.

The results are in the attached PDF. Much progress has been made since
DragonFly 2.10 was first released.

I would like to thank all of the IRC channel regulars who helped me setup
these tests and pointed out the configuration errors I made. Without their
advice, these benchmarks would not have been representative of real
performance levels.

-- 
Francois Tigeot
Attachment:
Pg-benchmarks.pdf
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdf00000.pdf
Type: application/octet-stream
Size: 63070 bytes
Desc: "Description: Adobe PDF document"
URL: <http://lists.dragonflybsd.org/pipermail/kernel/attachments/20111115/7dbe40ba/attachment-0019.obj>