| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Matt Clarkson <mattc(at)catalyst(dot)net(dot)nz> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 60 core performance with 9.3 |
| Date: | 2014-07-31 21:38:08 |
| Message-ID: | 20140731213807.GD5475@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reza Taheri | 2014-08-02 16:28:55 | Re: High rate of transaction failure with the Serializable Isolation Level |
| Previous Message | Scott Whitney | 2014-07-31 20:59:01 | Re: Setting a default format for timestamp |