X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1B52D4764BA for ; Fri, 31 Jan 2003 21:10:33 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id EA2454791D7 for ; Fri, 31 Jan 2003 19:48:45 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id D3DE643A91F; Fri, 31 Jan 2003 19:48:45 -0500 (EST) From: "Ben Borger" X-Newsgroups: comp.databases.postgresql.interfaces Subject: Apache child processes making multiple persistent database connections via Apache::DBI Date: Fri, 31 Jan 2003 18:47:20 -0600 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 18 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-interfaces@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/13 X-Sequence-Number: 3634 Hello, Is it normal for Apache child threads to be opening more than one persistent database connection to Postgres? DBI 1.19, Apache::DBI 0.88 In Apache's configuration I have the maximum threads limited to 12, and Postgres is set to allow a maximum of 32 connections. No other apps or users. Periodically I receive an error that there are too many connections to the database already and the connect attempt is refused. Does this infer a programming problem or Apache/Postgresql configuration problem, or is it normal, in which case what is the recommended ratio of threads to database connections? Thanks!