Re: rowcount estimate varies WRT partitionwise_join - Mailing list pgsql-hackers

From Tom Lane
Subject Re: rowcount estimate varies WRT partitionwise_join
Date
Msg-id 12565.1539534055@sss.pgh.pa.us
Whole thread Raw
In response to rowcount estimate varies WRT partitionwise_join  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> I was crosseyed yesterday due to merge conflicts, but this still seems odd.
> I thought that final row counts would not vary with the details of the chosen
> plan.  Which seems to hold true when I disable parallel join or hash join, but
> not for PWJ.

There are good reasons why that's not enabled by default yet ;-)

            regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] removing abstime, reltime, tinterval.c, spi/timetravel
Next
From: John Naylor
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables