2016-03-01 15:45 GMT+01:00 Tom Lane <t...@sss.pgh.pa.us>: > 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. >
aha, Thank you for explain Regards Pavel > > regards, tom lane >