Greg Stark <gsst...@mit.edu> wrote: > Gokulakannan Somasundaram <gokul...@gmail.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
