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

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: PATCH: use foreign keys to improve join estimates v1
Дата
Msg-id 126fbff3-cdd7-2d0d-7d5e-a61598da1ea6@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: PATCH: use foreign keys to improve join estimates v1  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Hi,

On 04/07/2016 01:23 PM, Simon Riggs wrote:
> On 7 April 2016 at 00:15, Tomas Vondra <tomas.vondra@2ndquadrant.com
> <mailto:tomas.vondra@2ndquadrant.com>> wrote:
>
>
>     Right. Fixed.
>
>
> 0001 committed. I added comments and a fastpath when no triggers are
> present.
>
>
> For 0002, I would be more comfortable adding
>    enable_fk_plans = on (true) | off
>
> even if we decided to remove that parameter that before release.

Attached is 0002 with the GUC added. I certainly believe we should think
twice before keeping the GUC in the final release - it's definitely
useful for testing etc. but I'm afraid it'd be just another tuning knob
for regular users.

regards

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

Вложения

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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: IF (NOT) EXISTS in psql-completion
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: PATCH: use foreign keys to improve join estimates v1