Re: max_parallel_degree context level

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: max_parallel_degree context level
Дата
Msg-id CA+TgmoaDjWfpkeWT83kEyTwMn7PdxyZf7d_GMFHNXBYMvgPoUw@mail.gmail.com
обсуждение исходный текст
Ответ на max_parallel_degree context level  (Thom Brown <thom@linux.com>)
Ответы Re: max_parallel_degree context level  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
On Thu, Feb 11, 2016 at 7:40 AM, Thom Brown <thom@linux.com> wrote:
> As it currently stands, max_parallel_degree is set to a superuser
> context, but we probably want to discuss whether we want to keep it
> this way prior to releasing 9.6.  Might we want to reduce its level so
> that users can adjust it accordingly?  They'd still be limited by
> max_worker_processes, so they'd at least be constrained by that
> setting.

I don't have a clue why it's like that.  It seems like it should be
PGC_USERSSET just like, say, work_mem.  I think that's just brain fade
on my part, and I think the current setting will be really
inconvenient for unprivileged users: as it is, they have no way to
turn parallel query off.  Unless somebody objects, I'll go change
that.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [PATCH] Refactoring of LWLock tranches
Следующее
От: Thom Brown
Дата:
Сообщение: Invalid user-level setting = confusing error message