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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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