Postgres Pro
Downloads
Home   >   mailing lists

Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman) - Mailing list pgsql-performance

From Greg Smith
Subject Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
Date
Msg-id alpine.GSO.2.01.0903171835001.19550@westnet.com
Whole thread Raw
In response to parallelizing slow queries for multiple cores (PostgreSQL + Gearman)  (Marinos Yannikos <mjy@geizhals.at>)
List pgsql-performance
Tree view 
On Tue, 17 Mar 2009, Marinos Yannikos wrote:

> It should be easy to implement this for any of the various connection
> pooling solutions also.

pgpool-II has something very similar in its "Parallel Mode", and the
example given at
http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html looks
just like your example.  I wonder if anyone has tried using that feature
but just pointing pgpool-II at the same database instance multiple times?

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Marinos Yannikos
Date:
Subject: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
Next
From: Simon Riggs
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4