Re: Skylake-S warning

From: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
To: Daniel Wood <hexexpert(at)comcast(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Skylake-S warning
Date: 2018-10-04 06:54:57
Message-ID: 6013cab6-0e7f-7938-cd37-72639d80af01@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2018-10-04 06:59:36 Re: executor relation handling
Previous Message Ideriha, Takeshi 2018-10-04 04:27:04 RE: Protect syscache from bloating with negative cache entries