Greg Stark <gsstark@mit.edu> wrote:
> Gokulakannan Somasundaram <gokul007@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