| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, me(at)benjaminarai(dot)com, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Parrallel query execution for UNION ALL Queries |
| Date: | 2007-07-19 10:14:29 |
| Message-ID: | 200707191214.32047.dfontaine@hi-media.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Hi,
Le mercredi 18 juillet 2007, Jonah H. Harris a écrit :
> On 7/18/07, Benjamin Arai <me(at)benjaminarai(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ottavio Campana | 2007-07-19 10:15:17 | memory leakage in libpg? |
| Previous Message | Björn Lundin | 2007-07-19 08:46:41 | Re: DBI/DBD::Pg and transactions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2007-07-19 14:30:43 | Re: [PERFORM] Parrallel query execution for UNION ALL Queries |
| Previous Message | Kalle Hallivuori | 2007-07-19 07:23:38 | Re: improvement suggestions for performance design |