Does Postgresql 10 query partitions in parallel?

From: Maltsev Eduard <emaltsev(at)intellias(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Does Postgresql 10 query partitions in parallel?
Date: 2017-12-06 13:11:39
Message-ID: CAO5258=ZujLDMM4DgNZAf4AoDEn2=xwY6vj1owb5T7AU5k11-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm curious if the new feature of Postgresql allows to take advantage of
multiple cpus on server, and multiple servers (fdw), for larger read only
queries (Data mining). In general there should be some worker that queries
partitions and merges the results, and I expect it to be done in parallel.
This becomes critical when foreign tables are used, I suppose.

Thank you.
Eddie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2017-12-06 13:24:43 Re: a back up question
Previous Message Bruyninckx Kristof 2017-12-06 13:07:07 replication terminated by primary server