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

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: PATCH: use foreign keys to improve join estimates v1
Дата
Msg-id CAKJS1f9_tsFS6CH9_=g8rO-CQu_4ycowOOXe1W50m9w2-mcKbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PATCH: use foreign keys to improve join estimates v1  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: PATCH: use foreign keys to improve join estimates v1  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
On 24 December 2015 at 16:32, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:


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.

Hi,

I'm not sure that I agree with this being set to "Needs review". The last progress that I see made on this was me hacking at the patch to remove some equivalence class limitations. I think the logical next step would be for you to look at these changes and either accept or reject them. So does that not suit "Waiting on author" better than "Needs review" ?

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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Haribabu Kommi
Дата:
Сообщение: Re: pg_hba_lookup function to get all matching pg_hba.conf entries
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: On-demand running query plans using auto_explain and signals