From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: Guido Neitzer <guido.neitzer@pharmaline.de>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: t1000/t2000 sun-servers
Date: Mon, 06 Mar 2006 17:11:29 -0500
Message-ID: <440CB391.2090402@sun.com> (raw)
In-Reply-To: <0EED23D8-4ECF-498B-8AF6-A453A0E34702@pharmaline.de>
References: <b41c75520603060105k6899d020j@mail.gmail.com>
<ddcd549e0603060630i68476a8am34a4c16b6f46cb4f@mail.gmail.com>
<440C974D.7000808@sun.com>
<0EED23D8-4ECF-498B-8AF6-A453A0E34702@pharmaline.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: J.K.Shah@Sun.COM, guido.neitzer@pharmaline.de
Subject: Re: t1000/t2000 sun-servers
In-Reply-To: <440CB391.2090402@sun.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox