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 0721732A2B4 for ; Fri, 1 Oct 2004 06:46:28 +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 61130-09 for ; Fri, 1 Oct 2004 05:46:24 +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 DAF7032A29B for ; Fri, 1 Oct 2004 06:46:23 +0100 (BST) Received: from [82.68.132.233] (82-68-132-233.dsl.in-addr.zen.co.uk [82.68.132.233]) by bayswater1.ymogen.net (Postfix) with ESMTP id C6DBFA36F8; Fri, 1 Oct 2004 06:46:21 +0100 (BST) Message-ID: <415CEE8E.8060805@ymogen.net> Date: Fri, 01 Oct 2004 06:43:42 +0100 From: Matt Clark User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" Cc: Postgresql Performance Subject: Re: Caching of Queries References: <00e801c4a4b6$5526dd30$8300a8c0@solent> <1096306670.40463.173.camel@jester> <41587867.4090505@ymogen.net> <20040930221107.GP1297@decibel.org> In-Reply-To: <20040930221107.GP1297@decibel.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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: 200410/1 X-Sequence-Number: 8477 >If you're not using a connection pool of some kind then you might as >well forget query plan caching, because your connect overhead will swamp >the planning cost. This does not mean you have to use something like >pgpool (which makes some rather questionable claims IMO); any decent web >application language/environment will support connection pooling. > > Hmm, a question of definition - there's a difference between a pool and a persistent connection. Pretty much all web apps have one connection per process, which is persistent (i.e. not dropped and remade for each request), but not shared between processes, therefore not pooled.