Pavel Stehule <pavel.steh...@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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to