Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Sort returns more rows than seq scan?
Date
Msg-id CAFj8pRAtegy_7o=0rmGLQUv8Nu08mXi7GxGAjsAYumxemvo4bA@mail.gmail.com
Whole thread Raw
Responses Re: Sort returns more rows than seq scan?
List pgsql-hackers
Tree view
Hi

I don't understand how is possible to get more rows from Sort node than in nested seq scan?

  http://explain.depesz.com/s/568O

Sec scan returns 1.6M rows, Sort returns 2.7M rows

Regards

Pavel

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: WIP: Upper planner pathification
Next
From: Craig Ringer
Date:
Subject: Re: Equivalent of --enable-tap-tests in MSVC scripts