Re: Slow "not in array" operation

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Slow "not in array" operation
Дата
Msg-id CAHOFxGpt73epD-gYH32u9pOZJkvEO=iNstGJ+jkSkd59LuEtMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow "not in array" operation  (Marco Colli <collimarco91@gmail.com>)
Ответы Re: Slow "not in array" operation  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Slow "not in array" operation  (Marco Colli <collimarco91@gmail.com>)
Список pgsql-performance
It is very interesting to me that the optimizer chose a parallel sequential scan rather than an index scan on either of your indexes that start with project_id that also reference trashed_at.

1) Are you running on SSD type storage? Has random_page_cost been lowered to 1-1.5 or so (close to 1 assumes good cache hits)?
2) It seems you have increased parallel workers. Have you also changed the startup or other cost configs related to how inclined the system is to use sequential scans?
3) If you disable sequential scan, what does the plan look like for this query? (SET ENABLE_SEQSCAN TO OFF;)

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

Предыдущее
От: Marco Colli
Дата:
Сообщение: Re: Slow "not in array" operation
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Slow "not in array" operation