From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: Neil Saunders <n.j.saunders@gmail.com>
Cc: Claus Guttesen <kometen@gmail.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: t1000/t2000 sun-servers
Date: Mon, 06 Mar 2006 15:10:53 -0500
Message-ID: <440C974D.7000808@sun.com> (raw)
In-Reply-To: <ddcd549e0603060630i68476a8am34a4c16b6f46cb4f@mail.gmail.com>
References: <b41c75520603060105k6899d020j@mail.gmail.com>
<ddcd549e0603060630i68476a8am34a4c16b6f46cb4f@mail.gmail.com>
Suggestions for benchmarks on Sun Fire T2000...
* Don't try DSS or TPC-H type of test with Postgres on Sun Fire T2000
Since such queries tend to have one connection, it will perform badly
with Postgre since it will use only one hardware virtual CPU of the
available 32 virtual CPU on Sun Fire T2000. (Oracle/DB2 have ways of
breaking the queries into multiple processes and hence use multiple
virtual CPUs on Sun Fire T2000, PostgreSQL cannot do the same in such cases)
* Use OLTP Type of benchmark
Where you have more than 30 simultaneous users/connections doing work on
Postgres without bottlenecking on datafiles of course :-)
* Use multiple databases or instances of Postgresql
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.
For your /etc/system use the parameters as mentioned in
http://www.sun.com/servers/coolthreads/tnb/parameters.jsp
For hints on setting it up for Postgresql refer to other databases setup on
http://www.sun.com/servers/coolthreads/tnb/applications.jsp
If you get specific performance problems send email to
pgsql-performance@postgresql.org
Regards,
Jignesh
Neil Saunders wrote:
>I may be able to organize a test on a T2000 if someone could give
>advice as to an appropriate test to run...
>
>Cheers,
>
>Neil
>
>On 3/6/06, Claus Guttesen <kometen@gmail.com> wrote:
>
>
>>Hi.
>>
>>Has anybody tried the new Sun "cool-thread" servers t1000/t2000 from
>>Sun? I'd love to see benchmarks with Solaris 10 and pg 8.1.
>>
>>regards
>>Claus
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
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, n.j.saunders@gmail.com, kometen@gmail.com
Subject: Re: t1000/t2000 sun-servers
In-Reply-To: <440C974D.7000808@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