Re: Parallel Seq Scan

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Parallel Seq Scan
Дата
Msg-id 20150111102722.GR3062@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Parallel Seq Scan  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Parallel Seq Scan  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: Parallel Seq Scan  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Thu, Jan 8, 2015 at 2:46 PM, Stephen Frost <sfrost@snowman.net> wrote:
> > Yeah, if we come up with a plan for X workers and end up not being able
> > to spawn that many then I could see that being worth a warning or notice
> > or something.  Not sure what EXPLAIN has to do anything with it..
>
> That seems mighty odd to me.  If there are 8 background worker
> processes available, and you allow each session to use at most 4, then
> when there are >2 sessions trying to do parallelism at the same time,
> they might not all get their workers.  Emitting a notice for that
> seems like it would be awfully chatty.

Yeah, agreed, it could get quite noisy.  Did you have another thought
for how to address the concern raised?  Specifically, that you might not
get as many workers as you thought you would?
Thanks,
    Stephen

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Transactions involving multiple postgres foreign servers
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Parallel Seq Scan