Fix possible duplicate tuples while GiST scan. Now page is processed
Teodor Sigaev <teodor@sigaev.ru>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/gist/gistget.c | modified | +93 −90 |
| src/backend/access/gist/gistscan.c | modified | +14 −1 |
| src/include/access/gist_private.h | modified | +8 −1 |