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