e this is understandable, English is not my
native language 😉).
Regards,
Sigrid
-Original Message-
From: David Rowley
Sent: Wednesday, November 4, 2020 9:13 PM
To: Ehrenreich, Sigrid
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Partition pruning with joins
On Wed, 4 Nov 2
On Wed, 4 Nov 2020 at 02:20, Ehrenreich, Sigrid wrote:
>
> -- Statement
> explain SELECT
> count(*)
> FROM
> dim INNER JOIN fact ON (dim.part_key=fact.part_key)
> WHERE dim.part_key >= 110 and dim.part_key <= 160;
>
> Plan shows me, that all partitions are scanned:
> Aggregate (cost=461.00..461.0
PM
To: Ehrenreich, Sigrid ;
pgsql-performance@lists.postgresql.org
Subject: Re: Partition pruning with joins
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 p
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
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
