Re: Inaccurate (sometimes wildly so) row estimates for simple join

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Inaccurate (sometimes wildly so) row estimates for simple join
Дата
Msg-id CAHOFxGpFXtZvnCeqZ3Rcy-6MnkDCRKSNe_mLOdijP+hh+wt8Ww@mail.gmail.com
обсуждение исходный текст
Ответ на Inaccurate (sometimes wildly so) row estimates for simple join  (Greg Nolle <greg.nolle@voidbridge.com>)
Ответы Re: Inaccurate (sometimes wildly so) row estimates for simple join
Список pgsql-general
Дерево обсуждения
On Fri, May 22, 2020 at 7:27 AM Greg Nolle <greg.nolle@voidbridge.com> wrote:
The crux seems to be that test_b does not have an even distribution for a_id values: it only has records for two of the values in the referenced table. This is how our real dataset is too and isn’t something we can really change.

How does it perform with extended statistics created for these two columns?

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Suggestion to improve query performance of data validation in proc.
Следующее
От: Greg Nolle
Дата:
Сообщение: Re: Inaccurate (sometimes wildly so) row estimates for simple join