Обсуждение: pgsql: Fix possible duplicate tuples while GiST scan.

Поиск
Список
Период
Сортировка

pgsql: Fix possible duplicate tuples while GiST scan.

От
teodor@postgresql.org (Teodor Sigaev)
Дата:
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_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/access/gist:
        gistget.c (r1.52.2.1 -> r1.52.2.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistget.c?r1=1.52.2.1&r2=1.52.2.2)
        gistscan.c (r1.61 -> r1.61.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistscan.c?r1=1.61&r2=1.61.2.1)
    pgsql/src/include/access:
        gist_private.h (r1.8 -> r1.8.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h?r1=1.8&r2=1.8.2.1)