Thread: backend and getConnection

backend and getConnection

From
Didier Bretin
Date:
Hello,

  I try to tune my postgresql server and I was asking me something: each time
I do a DriverManager.getConnection (), I notice that a backend
is opened. Do you confirm that the backend opening is a necessary (logical ?)
consequence of the DriverManger statement ?

Regards.
--
            .------------------------------------------------.
    .^.     | Didier Bretin, France | dbr@informactis.com    |
    /V\     |-----------------------| www.informactis.com    |
   // \\    |                       `------------------------|
  /(   )\   | Visit: http://www.fnh.org/                     |
   ^^-^^    `------------------------------------------------'

Re: backend and getConnection

From
"Dave Cramer"
Date:
Didier,

Yes, this is required. By definition getting a connection entails opening
one. I suppose the opening of the connection could be deferred until
actually used, however there may be situations where the connection may not
be legally opened; as such it is better to know ahead of actually trying to
use it.

Just out of curiosity what behaviour did you expect?

--dc--
----- Original Message -----
From: "Didier Bretin" <dbr@informactis.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Tuesday, May 15, 2001 11:11 AM
Subject: [JDBC] backend and getConnection


> Hello,
>
>   I try to tune my postgresql server and I was asking me something: each
time
> I do a DriverManager.getConnection (), I notice that a backend
> is opened. Do you confirm that the backend opening is a necessary (logical
?)
> consequence of the DriverManger statement ?
>
> Regards.
> --
>             .------------------------------------------------.
>     .^.     | Didier Bretin, France | dbr@informactis.com    |
>     /V\     |-----------------------| www.informactis.com    |
>    // \\    |                       `------------------------|
>   /(   )\   | Visit: http://www.fnh.org/                     |
>    ^^-^^    `------------------------------------------------'
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>