Re: Choosing parallel_degree

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Choosing parallel_degree
Дата
Msg-id 56EA9567.5090801@dalibo.com
обсуждение исходный текст
Ответ на Re: Choosing parallel_degree  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Choosing parallel_degree  (James Sewell <james.sewell@lisasoft.com>)
Список pgsql-hackers
On 17/03/2016 12:21, David Rowley wrote:
> On 18 March 2016 at 00:13, Julien Rouhaud <julien.rouhaud@dalibo.com> wrote:
>> With the current threshold, you need a table bigger than 8 MB to be able
>> to force parallel workers. I'm not sure there'll be benefits for
>> multiple workers on a table smaller than 8 MB, since setting up all the
>> parallel stuff takes time.
> 
> It would be really nice if it were possible to drop the setting really
> low, so that combined with a low parallel_setup_cost we could enable
> parallel query on small tables in the regression test suite.
> 
> 

Indeed. That could also be a use case for moving parallel_threshold to a
GUC, but not sure what'd be best.

-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Minor typos in optimizer/README
Следующее
От: David Rowley
Дата:
Сообщение: Re: Combining Aggregates