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

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Дата
Msg-id 8213532a-dc57-ccfa-7c89-c051f17df205@catalyst.net.nz
обсуждение исходный текст
Ответ на [PERFORM] Can postgresql plan a query using multiple CPU cores?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-performance
On 23/05/17 08:21, Clemens Eisserer wrote:
> 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?
>
> Thank you in advance and best regards, Clemens
>
>
Hi,

Might be worthwhile posting an example (query + EXPLAIN ANALYZE etc), so
we can see what type of queries are resulting in long plan times.

Cheers

Mark



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?