Re: PostgreSQL JDBC - Number of connections

On Sun, Sep 29, 2002 at 11:55:17AM +0100, Toby wrote:

> quite. forgive me if i'm wrong, but the backend spawns a new thread for
> each connection,

Not a new thread, a new _process_.  You're right, however, that at
some point you're better off to reduce the number of concurrent
conenctions, and manage them in a pool.  (This is true of any
database system -- even the trheading ones -- not just PostgreSQL.)

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110