Backends staying around - Mailing list pgsql-general

From Raymond O'Donnell
Subject Backends staying around
Date
Msg-id 3C0CBE65.30553.53DF6C@localhost
Whole thread Raw
Responses Re: Backends staying around
List pgsql-general
Hi all,

How long are backends supposed to hang around after a query is
executed? We're running into trouble because they're not going
away - this evening there were the full default complement of 32
sitting there, and the machine was refusing any more connections.
I've increased -N to 64 and -B to 128 after reading the FAQ, but
obvously I'd prefer if they quietly died after handling requests.

We are running Postgres 7.0.2, accessed from an NT4 server via
ADO 2.5 from IIS 4 (how's that for a mouthful of acronyms...?).

Many thanks.

--Ray O'Donnell


---------------------------------------------------------
Raymond O'Donnell            http://www.iol.ie/~rod/organ
rod@iol.ie                      The Irish Pipe Organ Page
---------------------------------------------------------

pgsql-general by date:

Previous
From: Luben Karavelov
Date:
Subject: Large tables management question
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Backends staying around