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 35B1932A1A3 for ; Thu, 30 Sep 2004 23:11:11 +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 62895-05 for ; Thu, 30 Sep 2004 22:11:06 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by svr1.postgresql.org (Postfix) with ESMTP id 15D0B32A18A for ; Thu, 30 Sep 2004 23:11:07 +0100 (BST) Received: by flake.decibel.org (Postfix, from userid 1001) id 4F4031C8B0; Thu, 30 Sep 2004 22:11:07 +0000 (GMT) Date: Thu, 30 Sep 2004 17:11:07 -0500 From: "Jim C. Nasby" To: Matt Clark Cc: Rod Taylor , 'Aaron Werman' , 'Scott Kirkwood' , Postgresql Performance Subject: Re: Caching of Queries Message-ID: <20040930221107.GP1297@decibel.org> References: <00e801c4a4b6$5526dd30$8300a8c0@solent> <1096306670.40463.173.camel@jester> <41587867.4090505@ymogen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41587867.4090505@ymogen.net> X-Operating-System: FreeBSD 4.10-RELEASE-p2 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i 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/348 X-Sequence-Number: 8476 On Mon, Sep 27, 2004 at 09:30:31PM +0100, Matt Clark wrote: > It's certainly the case that the typical web app (which, along with > warehouses, seems to be one half of the needy apps), could probably do > worse than use pooling as well. I'm not well up enough on pooling to > know how bulletproof it is though, which is why I included it in my list > of things that make me go 'hmm....'. It would be really nice not to > have to take both things together. 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. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"