Re: Sort returns more rows than seq scan? - Mailing list pgsql-hackers

Pavel Stehule <pavel.stehule@gmail.com> writes:
> I don't understand how is possible to get more rows from Sort node than in
> nested seq scan?

The "extra" rows are re-fetches triggered by mark/restore requests from
the parent mergejoin.  The EXPLAIN instrumentation counts re-fetches as
if they were new rows.

                        regards, tom lane