Re: Leftover processes on shutdown - Debian+JDBC - Mailing list pgsql-admin

From Chad R. Larson
Subject Re: Leftover processes on shutdown - Debian+JDBC
Date
Msg-id 4.2.2.20020814142044.00a79bc0@ecint.ecinet.com
Whole thread Raw
In response to Re: Leftover processes on shutdown - Debian+JDBC  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: Leftover processes on shutdown - Debian+JDBC
List pgsql-admin
At 12:48 PM 8/14/02 , Nick Fankhauser wrote:
>Then I tried changing "smart" to "fast", and did the same two tests. The
>results were exactly the same, so apparently "fast" mode does not forcibly
>disconnect clients as the Docs state.

As best I can tell, with "smart" the backend waits for the connection to go
away, "fast" waits for the current transaction to complete and then exits,
and with "immediate" the backend croaks right away (forcing a rollback and
recovery on the next start up).

If your Java servlet has requested some transaction that takes a =very=
long time to run, you'd see what you see.


         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona   85016-3228


pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC