Re: PostgreSQL JDBC - Number of connections

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-jdbc by date

  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