From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-general@postgresql.org
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: me@benjaminarai.com
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Date: Thu, 19 Jul 2007 12:14:29 +0200
Message-ID: <200707191214.32047.dfontaine@hi-media.com> (raw)
In-Reply-To: <36e682920707180921l149759e6jbb73e0c3f0460499@mail.gmail.com>
References: <39160.131.107.65.118.1184775275.squirrel@webmail.benjaminarai.com>
<36e682920707180921l149759e6jbb73e0c3f0460499@mail.gmail.com>
Hi,
Le mercredi 18 juillet 2007, Jonah H. Harris a écrit :
> On 7/18/07, Benjamin Arai <me@benjaminarai.com> wrote:
> > But I want to parrallelize searches if possible to reduce
> > the perofrmance loss of having multiple tables.
>
> PostgreSQL does not support parallel query. Parallel query on top of
> PostgreSQL is provided by ExtenDB and PGPool-II.
Seems to me that :
- GreenPlum provides some commercial parallel query engine on top of
PostgreSQL,
- plproxy could be a solution to the given problem.
https://developer.skype.com/SkypeGarage/DbProjects/PlProxy
Hope this helps,
--
dim
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dfontaine@hi-media.com, pgsql-general@postgresql.org, jonah.harris@gmail.com, me@benjaminarai.com
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries
In-Reply-To: <200707191214.32047.dfontaine@hi-media.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox