From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: domenico febbo <mimmopasticcio@gmail.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
Cc: pgsql-performance@postgresql.org list <pgsql-performance@postgresql.org>
Subject: Re: hyperthreadin low performance
Date: Sat, 25 Jul 2015 16:10:30 +1200
Message-ID: <55B30C36.1090607@catalyst.net.nz> (raw)
In-Reply-To: <CALqvQ1ND4YWvNBvgQ9g5PqC1GMvwbcGWjPgiFPP61rQDffA4dw@mail.gmail.com>
References: <55ADB586.2010406@audifarma.com.co>
<CAKJS1f_pAPeff0yRg_LCg28p=dAfvURf-sTVH9NtP0vhF=Xqcg@mail.gmail.com>
<55AE0BE2.3040603@catalyst.net.nz>
<CALqvQ1ND4YWvNBvgQ9g5PqC1GMvwbcGWjPgiFPP61rQDffA4dw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 23/07/15 23:37, domenico febbo wrote:
> is the problem also in PostgreSQL 9.4.x?
> I'm going to buy a production's server with 4 sockets E7-4850 12 cores
> so 12*4 = 48 cores (and 96 threads using HT).
>
> What do you suggest?
> Using or not HT?
>
From my experience 9.4 is considerably better (we are using it on the
60 core box mentioned prev).
48 cores should be fine, enabling HT and asking Postgres to effectively
handle 96 could provoke issues. However it is reasonably easy to test -
tune shared_buffers and checkpoint segments sensibly and run pgbench for
a steadily increasing number of clients. With 48 cores you should
(hopefully) see a tps curve that increases and then gently flattens off
somewhere. If 96 cores are "too many" then you will see a tps curve that
initially increases then sharply drops.
Cheers
Mark
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, mimmopasticcio@gmail.com, david.rowley@2ndquadrant.com, jeisonb@audifarma.com.co
Subject: Re: hyperthreadin low performance
In-Reply-To: <55B30C36.1090607@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox