Re: PostgreSQL pre-fork speedup - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 20040505151037.GA12095@phlogiston.dyndns.org
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (sdv mailer <sdvmailer@yahoo.com>)
Responses Re: PostgreSQL pre-fork speedup  (sdv mailer <sdvmailer@yahoo.com>)
List pgsql-hackers
On Mon, May 03, 2004 at 11:59:45PM -0700, sdv mailer wrote:
> 
> Connection pooling (eg. SQLRelay) didn't work either
> because we needed to connect to hundreds of DB servers
> from each web server. Imagine having 200+ open
> connections on the web server and how many more of
> these connections remain idle. The situation gets

This sounds like a case where you probably ought to be using schema
support instead of many different databases, for the record.  I don't
see how pre forking is going to help you at all, because a connection
is to a database, so you're going to have to pick one, and it's
likely as not to be the wrong one.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ALTER TABLE TODO items
Next
From: Umberto Zappi
Date:
Subject: COPY command - CSV files