Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Fix possible duplicate tuples while GiST scan. - Mailing list pgsql-committers

From teodor@postgresql.org (Teodor Sigaev)
Subject pgsql: Fix possible duplicate tuples while GiST scan.
Date
Msg-id 20080823104138.93478755315@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/access/gist:
        gistget.c (r1.62 -> r1.62.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistget.c?r1=1.62&r2=1.62.2.1)
        gistscan.c (r1.65 -> r1.65.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistscan.c?r1=1.65&r2=1.65.2.1)
    pgsql/src/include/access:
        gist_private.h (r1.24 -> r1.24.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h?r1=1.24&r2=1.24.2.1)

pgsql-committers by date:

Previous
From: teodor@postgresql.org (Teodor Sigaev)
Date:
Subject: pgsql: Fix possible duplicate tuples while GiST scan.
Next
From: teodor@postgresql.org (Teodor Sigaev)
Date:
Subject: pgsql: Fix possible duplicate tuples while GiST scan.