Re: Postgres and SUN

T5120 and T5220 have 8 cores with 8 threads each resulting in 64
threads. Best way to view this is 64-vcpu server in 1U or 2U size.
Experience with PostgreSQL is varied on such boxes:

* Setup on such boxes does not use lot of cpus as most utilities only
use 1 vcpu at a time and hence can take a while to setup
* However after that if you run OLTP or Web 2.0 type queries (small
transactions with multiple users) or small reads and sometimes update
from thousands of user then this box is great and throughput handled is
quite remarkable.
* But if you use it for DSS or data warehousing or Long running query
with a small number of users, again since each query will use only 1
vcpu the resulting query could take a longer time on this 1.2 to 1.4Ghz
cores.

I am setting the expectations right. These boxes are great for OLTP,
scalability is also great though it depends on the workload. Eventually
I have seen that PostgreSQL saturates little before the box saturates
but by then you probably end up being one of the big OLTP customers
using Postgres handling hundreds to thousands of users:-)

-Jignesh

Thomas Bräutigam wrote:
> Hi Robert
>
> What do you think about the SUN T5120 or T5220 with a Postgres Database?
>
> Cheers Thomas
>
>
> -----Original Message-----
> From: Robert(dot)Lor(at)Sun(dot)COM [mailto:Robert(dot)Lor(at)Sun(dot)COM]
> Sent: Donnerstag, 3. April 2008 19:28
> To: Thomas Bräutigam
> Cc: pgsql-admin(at)postgresql(dot)org; Jignesh K. Shah
> Subject: Re: [ADMIN] Postgres and SUN
>
> Thomas,
>
> Thomas Bräutigam wrote:
>
>> Hi Zmi,
>>
>> Okay thanks for that advice. Sorry its my first day on a mailing list.
>>
>> But do Postgres have a special recommendation which SUN equipment runs perfect with a Postgres Database?
>>
>> A time for a query over 30 seconds I would say is to long. So the machine should be fast enough to handle it in 10-20 Seconds. Price for the Machine doesn't matter at all. The machine should just fit and can handle this kinda huge database.
>>
>>
> Sun has published a benchmark on the Sun Fire T2000 Server and the results are published here http://www.spec.org/jAppServer2004/results/res2007q3/jAppServer2004-20070703-00073.html
>
> Jignesh has also done tests on the following AMD and Intel systems, and I believe the results were quite good.
>
> http://www.sun.com/servers/entry/x4200/
> http://www.sun.com/servers/x64/x4450/
>
>
> Regards,
> -Robert
>
>
>
>
>
>