Greg Stark <[email protected]> wrote: > Gokulakannan Somasundaram <[email protected]> wrote: >> scan through the leaf pages. > > That doesn't work because when you split an index page any > sequential scan in progress will either see the same tuples twice > or will miss some tuples depending on where the new page is > allocated. Vacuum has a clever trick for solving this but it > doesn't work for arbitrarily many concurrent scans. It sounds like you're asserting that Index Scan nodes are inherently unreliable, so I must be misunderstanding you. -Kevin
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
