Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 07696633B7F;
	Mon,  9 Mar 2009 17:45:08 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 02396-04; Mon,  9 Mar 2009 17:45:01 -0300 (ADT)
X-Greylist: delayed 00:09:48.943658 by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from relay.pcl-ipout01.plus.net (relay.pcl-ipout01.plus.net
	[212.159.7.99])
	by mail.postgresql.org (Postfix) with ESMTP id DDF37632D77;
	Mon,  9 Mar 2009 17:45:00 -0300 (ADT)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ApoEABgatUnUnw4U/2dsb2JhbADRO4QFBg
Received: from pih-relay08.plus.net ([212.159.14.20])
	by relay.pcl-ipout01.plus.net with ESMTP; 09 Mar 2009 20:35:08 +0000
Received: from [80.229.150.39] (helo=pd600.barnhouse)
	by pih-relay08.plus.net with esmtp (Exim) id 1LgmBo-0004YK-9G;
	Mon, 09 Mar 2009 20:35:08 +0000
Received: from [192.168.0.87] (unknown [192.168.0.87])
	by pd600.barnhouse (Postfix) with ESMTP id F1EA13A239B;
	Mon,  9 Mar 2009 20:35:32 +0000 (GMT)
Message-ID: <49B57D82.4030706@mansionfamily.plus.com>
Date: Mon, 09 Mar 2009 20:35:14 +0000
From: James Mansion <james@mansionfamily.plus.com>
Organization: MsgWare
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
To: Dave Cramer <pg@fastcrypt.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Guillaume Smet <guillaume.smet@gmail.com>,
	Guillaume Cottenceau <gc@mnc.ch>,
	Mario Splivalo <mario.splivalo@megafon.hr>,
	pgsql-performance@postgresql.org, pgsql-jdbc@postgreSQL.org
Subject: Re: [PERFORM] Query much slower when run from postgres function
References: <49B51B60.6030600@megafon.hr> <27649.1236616294@sss.pgh.pa.us>
	<87fxhmmygj.fsf@meuh.mnc.lan>
	<1d4e0c10903091004m758d7ea2s91e33631be81215a@mail.gmail.com>
	<5165.1236618994@sss.pgh.pa.us>
	<491f66a50903091256n7fe4a3f6i93267d0d53b983cb@mail.gmail.com>
In-Reply-To: <491f66a50903091256n7fe4a3f6i93267d0d53b983cb@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Plusnet-Relay: 546587a11765b9aa8950d8f6fc37d3af
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200903/34
X-Sequence-Number: 19364


>
> The driver will use unnamed statements for all statements until it 
> sees the same statement N times where N is 5 I believe, after that it 
> uses a named statement.
>
>
Shame there's no syntax for it to pass the a table of the parameters to 
the server when it creates the named statement as planner hints.

James