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
