Re: Understanding bad estimate (related to FKs?)

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Understanding bad estimate (related to FKs?)
Дата
Msg-id CAHOFxGrUA2QJLLfF_fEWhyvh=e+J6C5FCDiOJvdk+5QZGj0W4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Understanding bad estimate (related to FKs?)  (Philip Semanchuk <philip@americanefficient.com>)
Ответы Re: Understanding bad estimate (related to FKs?)
Список pgsql-performance
The query I asked about in the original post of this thread has 13 relations in it. IIUC, that's 13! or > 6 billion possible plans. How did the planner pick one plan out of 6 billion? I'm curious, both for practical purposes (I want my query to run well) and also because it's fascinating.

Have you increased geqo_threshold and join_collapse_limit from the defaults?

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Understanding bad estimate (related to FKs?)
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Understanding bad estimate (related to FKs?)