Re: [PERFORM] t1000/t2000 sun-servers

2006-03-07 Thread Jim C. Nasby
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

[PERFORM] t1000/t2000 sun-servers

2006-03-06 Thread Claus Guttesen
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

Re: [PERFORM] t1000/t2000 sun-servers

2006-03-06 Thread Neil Saunders
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 [EMAIL PROTECTED] wrote: Hi. Has anybody tried the new Sun cool-thread servers t1000/t2000 from Sun? I'd love to see benchmarks with Solaris 10

Re: [PERFORM] t1000/t2000 sun-servers

2006-03-06 Thread Jignesh K. Shah
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

Re: [PERFORM] t1000/t2000 sun-servers

2006-03-06 Thread Guido Neitzer
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

Re: [PERFORM] t1000/t2000 sun-servers

2006-03-06 Thread Jignesh K. Shah
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