pgbench according to me is more io write intensive benchmark.
T2000 with its internal drive may not perform well with pgbench with a
high load. If you are using external storage, try it out.
I havent tried it out yet but let me know what you see.
-Jignesh
Guido Neitzer wrote:
On 06.03.2006, at 21:10 Uhr, Jignesh K. Shah wrote:
Like migrate all your postgresql databases to one T2000. You might
see that your average response time may not be faster but it can
handle probably all your databases migrated to one T2000.
In essence, your single thread performance will not speed up on Sun
Fire T2000 but you can certainly use it to replace all your
individual postgresql servers in your organization or see higher
scalability in terms of number of users handled with 1 server with
Sun Fire T2000.
How good is a pgbench test for evaluating things like this? I have
used it to compare several machines, operating systems and PostgreSQL
versions - but it was more or less just out of curiosity. The real
evaluation was made with "real life tests" - mostly scripts which
also tested the application server itself.
But as it was it's easy to compare several machines with pgbench, I
just did the tests and they were interesting and reflected the real
world not as bad as I had thought from a "benchmark".
So, personally I'm interested in a simple pgbench test - perhaps with
some more ( > 50) clients simulated ...
cug
