Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id A15709FB251 for ; Thu, 9 Nov 2006 08:56:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 47519-09 for ; Thu, 9 Nov 2006 08:56:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.ecircle.de (mail.ecircle.de [195.140.186.200]) by postgresql.org (Postfix) with ESMTP id 770589FB219 for ; Thu, 9 Nov 2006 08:56:37 -0400 (AST) Received: from einstein.muc.ecircle.de (einstein.muc.ecircle.de [192.168.1.7]) by mail.ecircle.de (READY) with ESMTP id A531E55C01A; Thu, 9 Nov 2006 13:56:35 +0100 (CET) Received: from [192.168.1.91] ([192.168.1.91]) by einstein.muc.ecircle.de with Microsoft SMTPSVC(6.0.3790.1830); Thu, 9 Nov 2006 13:56:04 +0100 Subject: Re: Keeping processes open for re-use From: Csaba Nagy To: Hilary Forbes Cc: postgres performance list In-Reply-To: <5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk> References: <5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk> Content-Type: text/plain Message-Id: <1163076964.2839.1.camel@coppola.muc.ecircle.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 09 Nov 2006 13:56:04 +0100 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 09 Nov 2006 12:56:05.0035 (UTC) FILETIME=[6AB7B7B0:01C703FE] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/87 X-Sequence-Number: 21857 On Thu, 2006-11-09 at 13:35, Hilary Forbes wrote: > [snip] Is there a way that we can achieve this in Postgres? We have a > situation whereby we have lots of web based users doing short quick > queries and obviously the start up time for a process must add to > their perceived response time. Yes: google for "connection pooling". Note that different solutions exist for different programming languages, so you should look for connection pooling for the language you're using. HTH, Csaba.