Postgres Pro
Downloads
Home   >   mailing lists

Re: 60 core performance with 9.3 - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: 60 core performance with 9.3
Date
Msg-id 20140731213807.GD5475@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: 60 core performance with 9.3  (Matt Clarkson <mattc@catalyst.net.nz>)
Responses Re: 60 core performance with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
Tree view 
Matt Clarkson wrote:

> The LWLOCK_STATS below suggest that ProcArrayLock might be the main
> source of locking that's causing throughput to take a dive as the client
> count increases beyond the core count.

> Any thoughts or comments on these results are welcome!

Do these results change if you use Heikki's patch for CSN-based
snapshots?  See
http://www.postgresql.org/message-id/539AD153.9000004@vmware.com for the
patch (but note that you need to apply on top of 89cf2d52030 in the
master branch -- maybe it applies to HEAD the 9.4 branch but I didn't
try).

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-performance by date:

Previous
From: Scott Whitney
Date:
Subject: Re: [ADMIN] Setting a default format for timestamp
Next
From: Reza Taheri
Date:
Subject: Re: High rate of transaction failure with the Serializable Isolation Level