Re: Choosing parallel_degree

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Choosing parallel_degree
Дата
Msg-id CANP8+jJZ-eM7coWfJOqqdELBrd_ixNeTTC3Y_SVJqq7Pr0z8qA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Choosing parallel_degree  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Choosing parallel_degree  (Amit Kapila <amit.kapila16@gmail.com>)
Re: Choosing parallel_degree  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On 8 April 2016 at 17:49, Robert Haas <robertmhaas@gmail.com> wrote:
 
With the patch, you can - if you wish - substitute
some other number for the one the planner comes up with.

I saw you're using AccessExclusiveLock, the reason being it affects SELECTs.

That is supposed to apply when things might change the answer from a SELECT, whereas this affects only the default for a plan.

Can I change this to a lower setting? I would have done this before applying the patch, but you beat me to it. 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Choosing parallel_degree
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Removing the TRACE_SORT macro