Skip site navigation (1) Skip section navigation (2)

Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Marinos Yannikos <mjy(at)geizhals(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
Date: 2009-03-17 22:38:44
Message-ID: alpine.GSO.2.01.0903171835001.19550@westnet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-performance by date

Next:From: Simon RiggsDate: 2009-03-17 22:59:38
Subject: Re: Proposal of tunable fix for scalability of 8.4
Previous:From: Marinos YannikosDate: 2009-03-17 21:57:44
Subject: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group