Re: [PERFORM] Parrallel query execution for UNION ALL Queries

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Дата
Msg-id 200707191214.32047.dfontaine@hi-media.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Parrallel query execution for UNION ALL Queries  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Список pgsql-general
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

Вложения

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

Предыдущее
От: Björn Lundin
Дата:
Сообщение: Re: DBI/DBD::Pg and transactions
Следующее
От: Steve Spicklemire
Дата:
Сообщение: Re: Query performance strangeness..