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
Re: Choosing parallel_degree |
| Список | 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
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: