2016-03-01 15:45 GMT+01:00 Tom Lane <[email protected]>: > Pavel Stehule <[email protected]> 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 >
