Re: Unexpected planner choice in simple JOIN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unexpected planner choice in simple JOIN
Дата
Msg-id 1895375.1767846864@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Unexpected planner choice in simple JOIN  (Mark Kirkwood <mark.kirkwood@gmail.com>)
Ответы Re: Unexpected planner choice in simple JOIN
Список pgsql-performance
Mark Kirkwood <mark.kirkwood@gmail.com> writes:
> Good suggestion. The results are...interesting:

It's clear that the planner is underestimating the costs of using a
parallel worker in your setup.  Try increasing parallel_setup_cost
and/or parallel_tuple_cost to bring things more in line with reality.

            regards, tom lane



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