Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2B0176330EE for ; Tue, 2 Mar 2010 19:01:55 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65050-01 for ; Tue, 2 Mar 2010 23:01:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from leary.csoft.net (leary.csoft.net [205.205.214.5]) by mail.postgresql.org (Postfix) with ESMTP id 2FA0264170D for ; Tue, 2 Mar 2010 18:46:22 -0400 (AST) Received: by leary.csoft.net (Postfix, from userid 1112) id EF8B7A3C7; Tue, 2 Mar 2010 17:46:19 -0500 (EST) Date: Tue, 2 Mar 2010 17:46:19 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Rainer Pruy cc: Tom Lane , "pgsql-performance@postgresql.org" Subject: Re: Query slowing down significantly?? In-Reply-To: <4B8C0C23.9000107@acrys.com> Message-ID: References: <4B8BB815.4060104@acrys.com> <17910.1267460132@sss.pgh.pa.us> <4B8BFDEF.1080006@acrys.com> <20628.1267467300@sss.pgh.pa.us> <4B8C0C23.9000107@acrys.com> User-Agent: Alpine 2.00 (BSO 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/40 X-Sequence-Number: 37865 On Mon, 1 Mar 2010, Rainer Pruy wrote: > It is a Java app, using jdbc, but through a proprietary persistence > framework. I'm just busy evaluating the effects on the app of > prohibiting prepared statements via jdbc. If this is not worthwhile, I'm > bound to some expensive reorganizations, sigh. You can disable the named statement by adding the parameter prepareThreshold=0 to your connection URL. Kris Jurka