| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> | 
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org | 
| Subject: | Re: PostgreSQL JDBC - Number of connections | 
| Date: | 2002-09-30 14:51:02 | 
| Message-ID: | 20020930105102.F1405@mail.libertyrms.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wall | 2002-09-30 16:55:00 | Re: limiting rows in an query | 
| Previous Message | Michael Paesold | 2002-09-30 13:27:15 | Re: limiting rows in an query |