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.
-- Craig Ringer