X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 70158329C82 for ; Thu, 23 Sep 2004 18:38:54 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10666-08 for ; Thu, 23 Sep 2004 17:38:35 +0000 (GMT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id D09BF329C70 for ; Thu, 23 Sep 2004 18:38:34 +0100 (BST) Received: from solent (unknown [213.165.136.10]) by bayswater1.ymogen.net (Postfix) with ESMTP id 58CACA2F6E; Thu, 23 Sep 2004 18:38:32 +0100 (BST) Reply-To: From: "Matt Clark" To: "'Jason Coene'" , "'Mr Pink'" , "'Scott Kirkwood'" Cc: Subject: Re: Caching of Queries Date: Thu, 23 Sep 2004 18:38:32 +0100 Organization: Ymogen Ltd Message-ID: <002001c4a194$25481810$8300a8c0@solent> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <200409231653.i8NGrUaX017580@ms-smtp-02.nyroc.rr.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/248 X-Sequence-Number: 8376 > I've looked at PREPARE, but apparently it only lasts > per-session - that's worthless in our case (web based > service, one connection per data-requiring connection). That's a non-sequitur. Most 'normal' high volume web apps have persistent DB connections, one per http server process. Are you really dropping DB connections and reconnecting each time a new HTTP request comes in? M