Re: Accounting for between table correlation

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Accounting for between table correlation
Дата
Msg-id CAHOFxGqA_cRbJWXPLOzzrmTE4NwBGy-zWpx-JE0vH4OdJi90RQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Accounting for between table correlation  (Alexander Stoddard <alexander.stoddard@gmail.com>)
Ответы Re: Accounting for between table correlation  (Alexander Stoddard <alexander.stoddard@gmail.com>)
Список pgsql-general
On Fri, Jan 15, 2021 at 10:22 AM Alexander Stoddard <alexander.stoddard@gmail.com> wrote:
The 'fast plans' use parallel seq scans. The 'slow plans' is using index scans. It appears a good query plan correctly predicts it should be bulk processing the tables but bad ones get fooled into trashing (hard disk, not SSD) by mispredicting too few rows to join between the tables. 

How many tables are involved? Are you sure it is stats getting updated causing the change in behavior? Are you hitting the genetic optimizer?

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Best tools to monitor and fine tune postgres
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Accounting for between table correlation