Re: Skylake-S warning - Mailing list pgsql-hackers

From Adrien Nayrat
Subject Re: Skylake-S warning
Date
Msg-id 6013cab6-0e7f-7938-cd37-72639d80af01@anayrat.info
Whole thread Raw
In response to Skylake-S warning  (Daniel Wood <hexexpert@comcast.net>)
Responses Re: Skylake-S warning  (Ants Aasma <ants.aasma@eesti.ee>)
List pgsql-hackers
On 10/3/18 11:29 PM, Daniel Wood wrote:
> If running benchmarks or you are a customer which is currently impacted by
> GetSnapshotData() on high end multisocket systems be wary of Skylake-S.
>
>
> Performance differences of nearly 2X can be seen on select only pgbench due to
> nothing else but unlucky choices for max_connections.  Scale 1000, 192 local
> clients on a 2 socket 48 core Skylake-S(Xeon Platinum 8175M @ 2.50-GHz) system. 
> pgbench -S
>

Hi,

Could it be related to :
https://www.postgresql.org/message-id/D2B9F2A20670C84685EF7D183F2949E2373E66%40gigant.nidsa.net
?




Attachment

pgsql-hackers by date:

Previous
From: "Ideriha, Takeshi"
Date:
Subject: RE: Protect syscache from bloating with negative cache entries
Next
From: Amit Langote
Date:
Subject: Re: executor relation handling