pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedt1000/t2000 sun-servers
6+ messages / 5 participants
[nested] [flat]
* t1000/t2000 sun-servers
@ 2006-03-06 09:05 Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Re: t1000/t2000 sun-servers Neil Saunders <n.j.saunders@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Claus Guttesen @ 2006-03-06 09:05 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: t1000/t2000 sun-servers
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
@ 2006-03-06 14:30 ` Neil Saunders <n.j.saunders@gmail.com>
2006-03-06 20:10 ` Re: t1000/t2000 sun-servers Jignesh K. Shah <J.K.Shah@Sun.COM>
0 siblings, 1 reply; 6+ messages in thread
From: Neil Saunders @ 2006-03-06 14:30 UTC (permalink / raw)
To: Claus Guttesen <kometen@gmail.com>; +Cc: pgsql-performance
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: t1000/t2000 sun-servers
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Re: t1000/t2000 sun-servers Neil Saunders <n.j.saunders@gmail.com>
@ 2006-03-06 20:10 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-06 21:24 ` Re: t1000/t2000 sun-servers Guido Neitzer <guido.neitzer@pharmaline.de>
0 siblings, 1 reply; 6+ messages in thread
From: Jignesh K. Shah @ 2006-03-06 20:10 UTC (permalink / raw)
To: Neil Saunders <n.j.saunders@gmail.com>; +Cc: Claus Guttesen <kometen@gmail.com>; pgsql-performance
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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: t1000/t2000 sun-servers
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Re: t1000/t2000 sun-servers Neil Saunders <n.j.saunders@gmail.com>
2006-03-06 20:10 ` Re: t1000/t2000 sun-servers Jignesh K. Shah <J.K.Shah@Sun.COM>
@ 2006-03-06 21:24 ` Guido Neitzer <guido.neitzer@pharmaline.de>
2006-03-06 22:11 ` Re: t1000/t2000 sun-servers Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-07 18:43 ` Re: t1000/t2000 sun-servers Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 2 replies; 6+ messages in thread
From: Guido Neitzer @ 2006-03-06 21:24 UTC (permalink / raw)
To: pgsql-performance
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
Attachments:
smime.p7s (application/pkcs7-signature, 2.4K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: t1000/t2000 sun-servers
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Re: t1000/t2000 sun-servers Neil Saunders <n.j.saunders@gmail.com>
2006-03-06 20:10 ` Re: t1000/t2000 sun-servers Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-06 21:24 ` Re: t1000/t2000 sun-servers Guido Neitzer <guido.neitzer@pharmaline.de>
@ 2006-03-06 22:11 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
1 sibling, 0 replies; 6+ messages in thread
From: Jignesh K. Shah @ 2006-03-06 22:11 UTC (permalink / raw)
To: Guido Neitzer <guido.neitzer@pharmaline.de>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: t1000/t2000 sun-servers
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Re: t1000/t2000 sun-servers Neil Saunders <n.j.saunders@gmail.com>
2006-03-06 20:10 ` Re: t1000/t2000 sun-servers Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-06 21:24 ` Re: t1000/t2000 sun-servers Guido Neitzer <guido.neitzer@pharmaline.de>
@ 2006-03-07 18:43 ` Jim C. Nasby <jnasby@pervasive.com>
1 sibling, 0 replies; 6+ messages in thread
From: Jim C. Nasby @ 2006-03-07 18:43 UTC (permalink / raw)
To: Guido Neitzer <guido.neitzer@pharmaline.de>; +Cc: pgsql-performance
On Mon, Mar 06, 2006 at 10:24:29PM +0100, 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 ...
I had the opportunity to do some dbt2 testing on Solaris and Sun
hardware; it's probably your best bet for a test. You'll need to
essentially fit the database into memory though, otherwise you'll be
completely I/O bound. Another issue is that currently the test framework
runs on the same machine as the database, so it's not very realistic in
that regard, but if you were to change that dependancy I'm pretty sure
OSBC would gratefully accept patches.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-03-07 18:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-06 09:05 t1000/t2000 sun-servers Claus Guttesen <kometen@gmail.com>
2006-03-06 14:30 ` Neil Saunders <n.j.saunders@gmail.com>
2006-03-06 20:10 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-06 21:24 ` Guido Neitzer <guido.neitzer@pharmaline.de>
2006-03-06 22:11 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
2006-03-07 18:43 ` Jim C. Nasby <jnasby@pervasive.com>
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