Re: [HACKERS] index-only scans versus serializable transactions

2012-09-04 Thread Kevin Grittner
"Kevin Grittner" wrote: > New version attached. Will apply if no further problems are found. Pushed to master and REL9_2_STABLE. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hack

Re: [HACKERS] index-only scans versus serializable transactions

2012-09-04 Thread Kevin Grittner
Tom Lane wrote: > "Kevin Grittner" writes: >> By not visiting the heap page for tuples, index-only scans fail to >> acquire all of the necessary predicate locks for correct behavior >> at the serializable transaction isolation level. The tag for the >> tuple-level predicate locks includes the xmi

Re: [HACKERS] index-only scans versus serializable transactions

2012-09-03 Thread Tom Lane
"Kevin Grittner" writes: > By not visiting the heap page for tuples, index-only scans fail to > acquire all of the necessary predicate locks for correct behavior at > the serializable transaction isolation level. The tag for the > tuple-level predicate locks includes the xmin, to avoid possible >

[HACKERS] index-only scans versus serializable transactions

2012-09-03 Thread Kevin Grittner
By not visiting the heap page for tuples, index-only scans fail to acquire all of the necessary predicate locks for correct behavior at the serializable transaction isolation level. The tag for the tuple-level predicate locks includes the xmin, to avoid possible problems with tid re-use. (This wa