Re: PostgreSQL and Ultrasparc T1 - Mailing list pgsql-performance

From David Lang
Subject Re: PostgreSQL and Ultrasparc T1
Date
Msg-id Pine.LNX.4.62.0512200706300.2807@qnivq.ynat.uz
Whole thread Raw
In response to Re: PostgreSQL and Ultrasparc T1  (Alan Stange <stange@rentec.com>)
Responses Re: PostgreSQL and Ultrasparc T1
List pgsql-performance
On Tue, 20 Dec 2005, Alan Stange wrote:

> Jignesh K. Shah wrote:
>> I guess it depends on what you term as your metric for measurement.
>> If it is just one query execution time .. It may not be the best on
>> UltraSPARC T1.
>> But if you have more than 8 complex queries running simultaneously,
>> UltraSPARC T1 can do well compared comparatively provided the application
>> can scale also along with it.
>
> I just want to clarify one issue here.   It's my understanding that the
> 8-core, 4 hardware thread (known as strands) system is seen as a 32 cpu
> system by Solaris.
> So, one could have up to 32 postgresql processes running in parallel on the
> current systems (assuming the application can scale).

note that like hyperthreading, the strands aren't full processors, their
efficiancy depends on how much other threads shareing the core stall
waiting for external things.

David Lang

pgsql-performance by date:

Previous
From: Alan Stange
Date:
Subject: Re: PostgreSQL and Ultrasparc T1
Next
From: Alan Stange
Date:
Subject: Re: PostgreSQL and Ultrasparc T1