| From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Backends staying around |
| Date: | 2001-12-04 12:15:33 |
| Message-ID: | 3C0CBE65.30553.53DF6C@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)ie The Irish Pipe Organ Page
---------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2001-12-04 13:00:54 | Re: Backends staying around |
| Previous Message | James Thornton | 2001-12-04 11:57:42 | Re: update returns 1, but no changes have been made |