RE: BUG #15917: Runtime Partition Pruning does not seem to work in PG 11

From: "dbman(at)sqlexec(dot)com" <dbman(at)sqlexec(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: "dbman(at)sqlexec(dot)com" <dbman(at)sqlexec(dot)com>
Subject: RE: BUG #15917: Runtime Partition Pruning does not seem to work in PG 11
Date: 2019-07-18 15:45:12
Message-ID: 0b484dfc-9cfb-6185-9bc4-0a6e1cbb757e@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi all,

Please close this bug ticket I created since it is not a problem
anymore.  I don't know if it was because I upgraded from 11.2 to 11.4 or
I wasn't reading the explain output correctly.  It does appear to work
even on different variations of unnordered joins where the key phrase,
"never executed", does show up on the explain output for the partitions
that do not contain the partition key values as implied by the join.

Thanks in advance.
Michael Vitale

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2019-07-18 20:25:02 Re: BUG #15896: pg_upgrade from 10-or-earlier: TRAP: FailedAssertion(»!(metad->btm_version >= 3)«
Previous Message Pavel Stehule 2019-07-18 14:27:23 Re: BUG #15908: Xpath operations fail