On Tue, Oct 7, 2014 at 10:51 AM, Andres Freund <and...@2ndquadrant.com> wrote: > On 2014-10-07 10:45:24 -0400, Robert Haas wrote: >> > It's not like it'd be significantly different today - in a read mostly >> > workload that's bottlenecked on ProcArrayLock you'll not see many >> > waits. There you'd have to count the total number of spinlocks cycles to >> > measure anything interesting. >> >> Hmm, really? I've never had to do that to find bottlenecks. > > How did you diagnose procarray contention in a readonly workload > otherwise, without using perf?
spindelays. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
