Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D6B43632971;
	Wed, 21 Apr 2010 12:44:25 -0300 (ADT)
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 43178-10; Wed, 21 Apr 2010 15:44:15 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 78C43632177;
	Wed, 21 Apr 2010 12:44:14 -0300 (ADT)
Received: by wyb39 with SMTP id 39so4129183wyb.19
	for <multiple recipients>; Wed, 21 Apr 2010 08:44:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:from:date:received:message-id:subject:to:cc:content-type;
	bh=RAvC35PA8D3RgAsurQHhaUBBn1B2bXE4i6u/8YkGM9U=;
	b=UoZCegXMVYXxAVp/tMtt7Uk8gMzNVZWv/p6J05fiwUiRU+Tg7SrznxLYVetUA19Z59
	VQ/lg7dgi+CMt95f+zy42vVQRy2/AYbk41KtHG2GVkjt+eia3qZ6LxOgKeoQEOTIFLsy
	VNh0v80XI9A/2AOwx0L3WUWJLZ4pIWspKGO8g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=hBh8ofHJH93lgtv+LtDu7OkqO1FcvbGxMgCDBq6+HIb6vhRMRfpieh6Yzab2rW/zz3
	0hWrhXMBdA7OlGTgyPXm/5/9/zSBagjJr8QLMa7tDdgNuQnfF8Wk9KjoYCO06Gc8bLz1
	jE3jKkJSXhiaIHiu6jigV158xtF0sHkhb+H6E=
MIME-Version: 1.0
Received: by 10.216.58.204 with HTTP; Wed, 21 Apr 2010 08:43:52 -0700 (PDT)
In-Reply-To: <24144.1271863826@sss.pgh.pa.us>
References: <q2sca24673e1004191633j10b1124amf1eb51f3bd84f19a@mail.gmail.com>
	<w2kca24673e1004200847k77429a1cra0a6f3560d407d8e@mail.gmail.com>
	<4BCD90D80200002500030BDD@gw.wicourts.gov>
	<x2zca24673e1004201229n653f4e69vd274af4a4aa22d09@mail.gmail.com>
	<4BCDC6B90200002500030C09@gw.wicourts.gov>
	<w2oca24673e1004201340p703b0121iaf852aa28695be65@mail.gmail.com>
	<alpine.BSO.2.00.1004201644280.6736@leary.csoft.net>
	<g2w603c8f071004210741y69db6e92p5a7d18c4fc2940a@mail.gmail.com>
	<q2qd4e11e981004210807ua364abbbua4ae2fb0a91ac053@mail.gmail.com>
	<24144.1271863826@sss.pgh.pa.us>
From: Nikolas Everett <nik9000@gmail.com>
Date: Wed, 21 Apr 2010 11:43:52 -0400
Received: by 10.216.180.82 with SMTP id i60mr5254165wem.107.1271864652295;
	Wed, 21 Apr 2010 08:44:12 -0700 (PDT)
Message-ID: <u2jd4e11e981004210843ya970697dp8e3d88dec74577ca@mail.gmail.com>
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re:
	[PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery
	result set
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Kris Jurka <books@ejurka.com>,
	Dave Crooke <dcrooke@gmail.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-jdbc@postgresql.org,
	pgsql-performance <pgsql-performance@postgresql.org>,
	Scott Carey <scott@richrelevance.com>
Content-Type: multipart/alternative; boundary=0016363ba3c4cd9ec20484c11041
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.345 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/56
X-Sequence-Number: 20467

--0016363ba3c4cd9ec20484c11041
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Apr 21, 2010 at 11:30 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> >> On Tue, Apr 20, 2010 at 5:05 PM, Kris Jurka <books@ejurka.com> wrote:
> >>> ... There are three ways to plan a PreparedStatement:
>
> FWIW, I think there is some consensus to experiment (in the 9.1 cycle)
> with making the server automatically try replanning of parameterized
> queries with the actual parameter values substituted.  It'll keep doing
> so if it finds that that produces a significantly better plan than the
> generic parameterized plan; which is what you'd expect if there's a
> chance to optimize a LIKE search, eliminate partitions, etc.
>
>                        regards, tom lane
>

That'd be wonderful.

--0016363ba3c4cd9ec20484c11041
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Wed, Apr 21, 2010 at 11:30 AM, Tom La=
ne <span dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.p=
a.us</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<div class=3D"im">&gt;&gt; On Tue, Apr 20, 2010 at 5:05 PM, Kris Jurka &lt;=
<a href=3D"mailto:books@ejurka.com">books@ejurka.com</a>&gt; wrote:<br>
</div>&gt;&gt;&gt; ... There are three ways to plan a PreparedStatement:<br=
>
<br>
FWIW, I think there is some consensus to experiment (in the 9.1 cycle)<br>
with making the server automatically try replanning of parameterized<br>
queries with the actual parameter values substituted. =A0It&#39;ll keep doi=
ng<br>
so if it finds that that produces a significantly better plan than the<br>
generic parameterized plan; which is what you&#39;d expect if there&#39;s a=
<br>
chance to optimize a LIKE search, eliminate partitions, etc.<br>
<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane<br>
</blockquote></div><br><div>That&#39;d be wonderful.</div>

--0016363ba3c4cd9ec20484c11041--