Re: PATCH: use foreign keys to improve join estimates v1 - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: PATCH: use foreign keys to improve join estimates v1
Date
Msg-id 567B675B.2060505@2ndquadrant.com
Whole thread Raw
In response to Re: PATCH: use foreign keys to improve join estimates v1  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: PATCH: use foreign keys to improve join estimates v1
List pgsql-hackers

On 12/24/2015 03:45 AM, Michael Paquier wrote:
> On Wed, Sep 30, 2015 at 10:12 AM, David Rowley
...
>> In the attached I've coded it to take the Min() selectivity for when the
>> same quals are matched more than once. I know this is not correct, but since
>> it seems impossible to obtain an exact estimate in this case, we'd need to
>> decide on some logic which does well in the average case.
>
> Is there still an interest for this patch? The last message of this
> thread has added a new version of the patch but the patch was still in
> "Waiting on author" state for a couple of months. Just guessing that
> the status was incorrect, I have moved it to next CF.

Yes, I still think the patch is useful. Thanks for moving it to the next 
commitfest and sorry for not updating the status.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PATCH: index-only scans with partial indexes
Next
From: Peter Geoghegan
Date:
Subject: Re: Using quicksort for every external sort run