pgsql: Fix possible duplicate tuples while GiST scan.

From: teodor(at)postgresql(dot)org (Teodor Sigaev)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix possible duplicate tuples while GiST scan.
Date: 2008-08-23 10:37:24
Message-ID: 20080823103724.D33D7755315@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix possible duplicate tuples while GiST scan. Now page is processed
at once and ItemPointers are collected in memory.

Remove tuple's killing by killtuple() if tuple was moved to another
page - it could produce unaceptable overhead.

Backpatch up to 8.1 because the bug was introduced by GiST's concurrency support.

Modified Files:
--------------
pgsql/src/backend/access/gist:
gistget.c (r1.74 -> r1.75)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistget.c?r1=1.74&r2=1.75)
gistscan.c (r1.70 -> r1.71)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistscan.c?r1=1.70&r2=1.71)
pgsql/src/include/access:
gist_private.h (r1.31 -> r1.32)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h?r1=1.31&r2=1.32)

Browse pgsql-committers by date

  From Date Subject
Next Message Teodor Sigaev 2008-08-23 10:40:03 pgsql: Fix possible duplicate tuples while GiST scan.
Previous Message Bruce Momjian 2008-08-23 03:12:50 Re: pgsql: Minor patch on pgbench 1.