Re: enable parallel query by default?

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: enable parallel query by default?
Дата
Msg-id CADkLM=cHQNF7EeQXX3p7OMcjbRyybt91MB6yKBVFZ3QQNviUzA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: enable parallel query by default?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
I think that's an argument to enable it till at least beta1. Let's
change the default, and add an item to the open items list to reconsider
then.



+1 during the beta, +0.95 for default thereafter.

I think that most databases in the past have defaulted to single-core unless otherwise stated because machines that had multiple cores were uncommon, and the query that could intelligently use parallel was even more uncommon. So for them, the name of the game was "plan stability".

Machines are architected to be multicore now, and that will be the norm going forward, as will larger workloads that can easily overwhelm a single CPU. So I think Postgres should just enable parallel out of the box.

Having said that, it seems like the sort of thing I'd want set-able on a per-user basis.

ALTER ROLE overly_needy_web_client SET max_parallel_degree = 1;
ALTER ROLE moar_powarrr SET max_parallel_degree = 32;

And of course this is my chance to re-ask that we not block the possibility of one day being able to set this value relative to the number of cores available on the machine, i.e. this user can have a parallel degree 2x the number of CPUs, this one can only have 0.25x as many CPUs. It would be nice to have our configurations adapt with the hardware.
 

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

Предыдущее
От: David Steele
Дата:
Сообщение: Re: 2016-01 Commitfest
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: proposal: make NOTIFY list de-duplication optional