pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Peter Darley <pdarley@kinesis-cem.com>
Cc: Ragnar Hafstaư <gnari@simnet.is>
Cc: Tatsuo Ishii <t-ishii@sra.co.jp>
Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL
Date: Tue, 25 Jan 2005 08:58:37 -0800
Message-ID: <200501250858.37157.josh@agliodbs.com> (raw)
In-Reply-To: <PDEOIIFFBIAABMGNJAGPKEPGDLAA.pdarley@kinesis-cem.com>
References: <PDEOIIFFBIAABMGNJAGPKEPGDLAA.pdarley@kinesis-cem.com>

Peter, Ragnar,

> > Are there ones that you use which might use several different connections
> > to send a series of queries from a single web-user, less than 5 seconds
> > apart?
>
> 	Using Apache/Perl I often have a situation where we're sending several
> queries from the same user (web client) within seconds, or even
> simultaneously, that use different connections.

So from the sound of it, the connection methods I've been using are the 
exception rather than the rule.   Darn, it worked well for us.  :-(

What this would point to is NOT being able to use Slony-I for database server 
pooling for most web applications.   Yes?  Users should look to pgCluster and 
C-JDBC instead.

BTW, Tatsuo, what's the code relationship between pgPool and pgCluster, if 
any?

--Josh

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



view thread (8+ messages)  latest in thread

Message-ID: <200501250858.37157.josh@agliodbs.com>
Permalink:  ../200501250858.37157.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200501250858.37157.josh@agliodbs.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: josh@agliodbs.com, pdarley@kinesis-cem.com, gnari@simnet.is, t-ishii@sra.co.jp
  Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL
  In-Reply-To: <200501250858.37157.josh@agliodbs.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