Postgres Pro
Downloads
Home   >   mailing lists

Re: SKIP LOCKED DATA (work in progress) - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: SKIP LOCKED DATA (work in progress)
Date
Msg-id CADLWmXU0ZZwKnJT+A=bm8AnBDTVJ-=kXr=Wcq4KMv6UC+B=-Lw@mail.gmail.com
Whole thread Raw
In response to SKIP LOCKED DATA (work in progress)  (Thomas Munro <munro@ip9.org>)
Responses Re: SKIP LOCKED DATA (work in progress)
List pgsql-hackers
Tree view
On 13 May 2014 23:06, Thomas Munro <munro@ip9.org> wrote:
A couple of years ago I posted an outline of a plan [1] and an
initial patch [2] for implementing SKIP LOCKED DATA.  I have
recently come back to this idea, rebased the patch and added a
simple isolation test -- please see attached.

I have attached a new version which copies the skipLocked member
in _copyPlanRowMark, _copyRowMarkClause and _copyLockClause.
Without these, SKIP LOCKED DATA didn't work in pl/pgsql (as reported
by David Rowley off-list).  (Also some whitespace changes.)

Best regards,
Thomas Munro
Attachment

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Cache invalidation bug in RelationGetIndexAttrBitmap()
Next
From: Andres Freund
Date:
Subject: Re: Cache invalidation bug in RelationGetIndexAttrBitmap()