Thanks for the explanation.

Dane


On Fri, Aug 4, 2023 at 11:07 AM Jeff Janes <jeff.ja...@gmail.com> wrote:

> On Fri, Aug 4, 2023 at 11:00 AM Dane Foster <studdu...@gmail.com> wrote:
>
>> Hello,
>>
>> I'm trying to understand a bit of weirdness in a plan output. There is a
>> sort node above a sequential scan node where the scan node produces 26,026
>> rows yet the sort node above it produces 42,995,408. How is it possible
>> to sort more data than you received?
>>
>
> This is normal for a merge join.  For every tie in the first input, the
> qualifying part of the 2nd input must be rescanned, and the rows are
> tallied again (in the sort node) each time they are rescanned.
>
> Cheers,
>
> Jeff
>
>>

Reply via email to