Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZrnXc-0007FR-E6 for pgsql-performance@arkaria.postgresql.org; Thu, 29 Oct 2015 13:46:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZrnXb-0001w0-SJ for pgsql-performance@arkaria.postgresql.org; Thu, 29 Oct 2015 13:46:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZrnXa-0001vE-LS for pgsql-performance@postgresql.org; Thu, 29 Oct 2015 13:46:54 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZrnXM-0004yQ-SY for pgsql-performance@postgresql.org; Thu, 29 Oct 2015 13:46:53 +0000 Received: from [192.168.27.120] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 5942321C415F; Thu, 29 Oct 2015 16:46:39 +0300 (MSK) Subject: Re: Scalability to more than 64 cores With PG 9.4 and RHEL 7.1 Kernel 3.10 To: Javier Muro , "pgsql-performance@postgresql.org" References: From: Alex Ignatov Message-ID: <5632233F.4040806@postgrespro.ru> Date: Thu, 29 Oct 2015 16:46:39 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 28.10.2015 8:04, Javier Muro wrote: > Has PostgreSQL 9.4 official Support on a system with more than 64 > legitimate cores? ( 72 Cores , 4 CPUs Intel(R) Xeon(R) CPU E7-8890 ) > > > > The work Robert Haas did to fix the CPU locking way back when showed > significant improvements up to 64, but so far as I know. > > > Thanks in Advance. Hello Javier! Our tests shows that PG 9.4 scales well up to 60 Intel cores. I.E pgbech -S and DB on tmpfs gave us 700 000 tps. After 60 соres s_lock is dominating in cpu usage%. 9.5 scales way better. -- Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance