Re: Postgres and SUN

Hi Jignesh,

Thanks for this information.

Did SUN make any other tests with SUN Machines and Postgres Databases?

Cheers Thomas

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Jignesh K. Shah
Sent: Freitag, 4. April 2008 15:14
To: Thomas Bräutigam
Cc: Robert(dot)Lor(at)Sun(dot)COM; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 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-20
> 070703-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
>
>
>
>
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin