Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group