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
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
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
Thanks!
Regards,
Sigrid
-Original Message-
From: Magnus Hagander
Sent: Thursday, October 29, 2020 10:57 AM
To: Ehrenreich, Sigrid
Cc: Tom Lane ; David Rowley ;
pgsql-performance@lists.postgresql.org
Subject: Re: Postgres Optimizer ignores information about foreign key
relationship
igrid
-Original Message-
From: Tom Lane
Sent: Wednesday, October 28, 2020 5:55 PM
To: Ehrenreich, Sigrid
Cc: David Rowley ; pgsql-performance@lists.postgresql.org
Subject: Re: Postgres Optimizer ignores information about foreign key
relationship, severly misestimating number of returned rows in
11:54 PM
To: David Rowley
Cc: Ehrenreich, Sigrid ;
pgsql-performance@lists.postgresql.org
Subject: Re: Postgres Optimizer ignores information about foreign key
relationship, severly misestimating number of returned rows in join
David Rowley writes:
> On Tue, 27 Oct 2020 at 06:54, Ehrenre
Hi Performance Guys,
I hope you can help me. I am joining two tables, that have a foreign key
relationship. So I expect the optimizer to estimate the number of the resulting
rows to be the same as the number of the returned rows of one of the tables.
But the estimate is way too low.
I have bui
