Craig Ringer wrote:
David Siebert wrote:
I am interesting in finding a good Postgres benchmark. I an not
interested in seeing how fast Postgres is compared to MySql, Firebird,
or any other SQL database.
What I am interested in is how file systems, memory, and X-64 vs X-32
effects the performance of Postgres.
It is more for my own curiosity to be honest. Right now Postgres is more
than fast enough for what I am doing.
Do you want to use PostgreSQL for any particular task? If so, the best
benchmark is probably one that simulates your specific workload.
Comparing generic benchmark results like pgbench etc may not usefully
reflect performance in real-world use with your load and your data.
and If you are running Solaris/OpenSolaris, DTrace is your friend.
Mayuresh
--
Craig Ringer