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
>