Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Can postgresql plan a query using multiple CPU cores? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Date
Msg-id 8213532a-dc57-ccfa-7c89-c051f17df205@catalyst.net.nz
Whole thread Raw
In response to [PERFORM] Can postgresql plan a query using multiple CPU cores?  (Clemens Eisserer <linuxhippy@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?
Next
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] Can postgresql plan a query using multiple CPU cores?