Re: [HACKERS] Regression in join selectivity estimations when usingforeign keys - Mailing list pgsql-hackers

From David Rowley
Subject Re: [HACKERS] Regression in join selectivity estimations when usingforeign keys
Date
Msg-id CAKJS1f9dzWgNNsQrJpu2uN_Cp=zXRBOAQ0cEMb5BD2do6izd+A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Regression in join selectivity estimations when using foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 20 June 2017 at 07:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm not totally satisfied that there isn't any case where the smallest
> selectivity hack is appropriate.  In the example you're showing here,
> the FK columns are independent so that we get more or less the right
> answer with or without the FK.  But in some quick testing I could not
> produce a counterexample proving that that heuristic is helpful;
> so for now let's can it.
>
> Thanks, and sorry again for the delay.

Many thanks for taking the time on this.

-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Is exec_simple_check_node still doing anything?
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] Regarding Postgres Dynamic Shared Memory (DSA)