Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
Date
Msg-id 1345771.1603904126@sss.pgh.pa.us
Whole thread Raw
In response to RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join  ("Ehrenreich, Sigrid" <Ehrenreich@consist.de>)
Responses RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join  ("Ehrenreich, Sigrid" <Ehrenreich@consist.de>)
List pgsql-performance
Tree view 
"Ehrenreich, Sigrid" <Ehrenreich@consist.de> writes:
> A patch would be very much appreciated.
> We are currently running on Version 12, but could upgrade to 13, if necessary.
> Could you send me a notification if you managed to program a patch for that?

I've pushed a patch for this to HEAD, but current thinking is that we
will not be back-patching it.  Still, if you're desperate you could
consider running a custom build of v13 with that patch --- a quick
check suggests that it would back-patch easily.  v12 would be a
slightly harder lift (I see one hunk doesn't apply) but probably
not by much.

https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=ad1c36b0709e47cdb3cc4abd6c939fe64279b63f

            regards, tom lane

pgsql-performance by date:

Previous
From: Mats Olsen
Date:
Subject: Re: Query Performance / Planner estimate off
Next
From: "Olivier Poquet"
Date:
Subject: query plan using partial index expects a much larger number of rows than is possible