Re: PostgreSQL JDBC - Number of connections - Mailing list pgsql-jdbc

From Andrew Sullivan
Subject Re: PostgreSQL JDBC - Number of connections
Date
Msg-id 20020930105102.F1405@mail.libertyrms.com
Whole thread Raw
In response to Re: PostgreSQL JDBC - Number of connections  (Toby <toby@paperjet.com>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Michael Paesold
Date:
Subject: Re: limiting rows in an query
Next
From: Felipe Schnack
Date:
Subject: Re: limiting rows in an query