pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Marinos Yannikos <mjy@geizhals.at>
Cc: pgsql-performance@postgresql.org
Subject: Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
Date: Tue, 17 Mar 2009 18:38:44 -0400 (EDT)
Message-ID: <alpine.GSO.2.01.0903171835001.19550@westnet.com> (raw)
In-Reply-To: <49C01CD8.8050109@geizhals.at>
References: <49C01CD8.8050109@geizhals.at>

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




view thread (3+ messages)  latest in thread

Message-ID: <alpine.GSO.2.01.0903171835001.19550@westnet.com>
Permalink:  ../alpine.GSO.2.01.0903171835001.19550@westnet.com/
Also on:    postgresql.org/message-id/alpine.GSO.2.01.0903171835001.19550@westnet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmith@gregsmith.com, mjy@geizhals.at
  Subject: Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman)
  In-Reply-To: <alpine.GSO.2.01.0903171835001.19550@westnet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox