Horton

Re: Overhead cost of Serializable Snapshot Isolation

Dan Ports <drkp@csail.mit.edu>

View thread
From: Dan Ports <drkp@csail.mit.edu>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Greg Sabino Mullane <greg@endpoint.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2011-10-10T21:55:10Z
Lists: pgsql-hackers 
On Mon, Oct 10, 2011 at 04:10:18PM -0500, Kevin Grittner wrote:
> Did you ever see much contention on
> SerializablePredicateLockListLock, or was it just
> SerializableXactHashLock?  I think the former might be able to use
> the non-blocking techniques, but I fear the main issue is with the
> latter, which seems like a harder problem.

No, not that I recall -- if SerializablePredicateLockListLock was on
the list of contended locks, it was pretty far down.

SerializableXactHashLock was the main bottleneck, and
SerializableXactFinishedListLock was a lesser but still significant
one.

Dan

-- 
Dan R. K. Ports              MIT CSAIL                http://drkp.net/