Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Дата
Msg-id CAFj8pRDj7xHV908VMF4hmwczrwtbjEeeYyAzLhT28hO9me7OtA@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Can postgresql plan a query using multiple CPU cores?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi

2017-05-22 22:21 GMT+02:00 Clemens Eisserer <linuxhippy@gmail.com>:
Hi,

I have a letancy-sensitive legacy application, where the time consumed
by query planning was always causing some headaches.
Currently it is running on postgresql-8.4 - will postgresql-10 support
generating plans using multiple CPU cores to reduce the time required
to generate a single plan?

 no. PostgreSQL 9.6 and higher uses more CPU only for execution.

For planner speed are important GUC parameters join_collapse_limit, from_collapse_limit and show geqo_threshold.

You can try to decrease geqo_threshold - with low geqo_threshold you can increase join_collapse_limit and from_collapse_limit

Regards

Pavel

Thank you in advance and best regards, Clemens


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Следующее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: [PERFORM] select subquery versus join subquery