Re: [PERFORM] Benchmarking PostgreSQL?

2004-01-25 Thread Ivan Voras
Tom Lane wrote: It is notoriously hard to get reproducible results from pgbench. However... - I'm running pgbench with 35 clients and 50 transactions/client (1) what scale factor did you use to size the database? One of the gotchas is that you need to use a scale factor at least as large as th

Re: [PERFORM] Benchmarking PostgreSQL?

2004-01-24 Thread Tom Lane
Ivan Voras <[EMAIL PROTECTED]> writes: > I'm conducting some benchmarking (mostly for fun and learning), and one > part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2). > I'm using pgbench from the contrib directory, but I'm puzzled by the > results. It is notoriously hard to g

[PERFORM] Benchmarking PostgreSQL?

2004-01-24 Thread Ivan Voras
I'm conducting some benchmarking (mostly for fun and learning), and one part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2). I'm using pgbench from the contrib directory, but I'm puzzled by the results. I have little experience in benchmarking, but I don't think I should be ge