Re: SSI memory mitigation & false positive degradation
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>
Cc: <drkp@csail.mit.edu>,<pgsql-hackers@postgresql.org>
Date: 2010-12-29T18:05:00Z
Lists: pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote: > Looking at the predicate lock splitting, it occurs to me that > it's possible for a non-serializable transaction to be canceled if > it needs to split a predicate lock held by a concurrent > serializable transaction, and you run out of space in the shared > memory predicate lock area. Good point. We don't want that, for sure. > Any chance of upgrading the lock to a relation lock, or killing > the serializable transaction instead? Absolutely. Good suggestion. Thanks! -Kevin