On Tue, 2020-11-03 at 13:20 +, Ehrenreich, Sigrid wrote:
> I would like to join a partitioned table and have the joined columns in the
> where clause to be used for partition pruning.
> From some readings in the internet, I conclude that this was not possible in
> v12. I hoped for the
> “imp
> On Nov 2, 2020, at 10:17 PM, Tomas Vondra
> wrote:
>
> On Mon, Nov 02, 2020 at 03:08:12PM -0500, Tom Lane wrote:
>> Philip Semanchuk writes:
>>> The query I asked about in the original post of this thread has 13
>>> relations in it. IIUC, that's 13! or > 6 billion possible plans. How did
> On Nov 2, 2020, at 6:09 PM, Michael Lewis wrote:
>
> The query I asked about in the original post of this thread has 13 relations
> in it. IIUC, that's 13! or > 6 billion possible plans. How did the planner
> pick one plan out of 6 billion? I'm curious, both for practical purposes (I
> wa
Hi,
I would like to join a partitioned table and have the joined columns in the
where clause to be used for partition pruning.
From some readings in the internet, I conclude that this was not possible in
v12. I hoped for the “improvements in partition pruning” in v13, but it seems
to me, that i
