Re: PATCH: use foreign keys to improve join estimates v1

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: PATCH: use foreign keys to improve join estimates v1
Дата
Msg-id 567B675B.2060505@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: PATCH: use foreign keys to improve join estimates v1  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: PATCH: use foreign keys to improve join estimates v1  (David Rowley <david.rowley@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: PATCH: index-only scans with partial indexes
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Using quicksort for every external sort run