From: | "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> |
---|---|
To: | Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de> |
Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: t1000/t2000 sun-servers |
Date: | 2006-03-06 22:11:29 |
Message-ID: | 440CB391.2090402@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | i.v.r. | 2006-03-07 00:15:55 | Help understanding indexes, explain, and optimizing a query |
Previous Message | Guido Neitzer | 2006-03-06 21:24:29 | Re: t1000/t2000 sun-servers |