Re: rowcount estimate varies WRT partitionwise_join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: rowcount estimate varies WRT partitionwise_join
Date: 2018-10-14 16:20:55
Message-ID: 12565.1539534055@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2018-10-14 16:29:28 Re: WIP: Avoid creation of the free space map for small tables
Previous Message Tom Lane 2018-10-14 16:16:49 Re: [HACKERS] removing abstime, reltime, tinterval.c, spi/timetravel