On Dec 26, 2007 10:52 PM, Guillaume Smet <guillaume.smet@xxxxxxxxx> wrote: > Let's go with 8.2.5 on the same server (-s 100 / 16 clients / 50k > transactions per client / only read using -S option): > 64MB: 33814 tps > 512MB: 35833 tps > 1024MB: 36986 tps > It's more consistent with what I expected. I had the same numbers with 8.3b4.x86_64 RPMs compiled by Devrim than with the ones I compiled myself. While discussing with Devrim, I checked the .spec with a little more attention and... I noticed that beta RPMs are by default compiled with --enable-debug and --enable-cassert which doesn't help them to fly fast... I did all my previous benchmarks with binaries compiled directly from CVS so I didn't notice it before and this new server was far faster than the box I tested 8.3devel before so I wasn't surprised by the other results.. So, the conclusion is: if you really want to test/benchmark 8.3beta4 using the RPM packages, you'd better compile your own set of RPMs using --define "beta 0". Really sorry for the noise but anyway quite happy to have discovered the pgbench-tools of Greg. I hope it will be useful to other people. I'll post new results yesterday with a clean beta4 install. -- Guillaume ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
