Re: Choosing parallel_degree

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Choosing parallel_degree
Дата
Msg-id CAKJS1f-veM7c7hjQK-gqGXdPrWR5E=LeZ9qzUTAgje2T8RwvRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Choosing parallel_degree  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Ответы Re: Choosing parallel_degree  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Список pgsql-hackers
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.


-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Choosing parallel_degree
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Minor typos in optimizer/README