Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 56563634008
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  3 Nov 2009 20:18:35 -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 48332-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  4 Nov 2009 00:18:27 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vexbert.mr-paradox.net (vexbert.mr-paradox.net
	[198.145.180.174])
	by mail.postgresql.org (Postfix) with ESMTP id 5DCC76336B0
	for <pgsql-performance@postgresql.org>;
	Tue,  3 Nov 2009 20:18:26 -0400 (AST)
Received: by vexbert.mr-paradox.net (Postfix, from userid 18391)
	id C68A08459C; Tue,  3 Nov 2009 19:18:25 -0500 (EST)
Date: Tue, 3 Nov 2009 16:18:25 -0800
From: David Kerr <dmk@mr-paradox.net>
To: Chris <dmagick@gmail.com>
Cc: Craig Ringer <craig@postnewspapers.com.au>,
	pgsql-performance@postgresql.org
Subject: Re: Optimizer + bind variables
Message-ID: <20091104001825.GA79191@mr-paradox.net>
References: <20091103174729.GA55736@mr-paradox.net>
	<4AF0C014.4090000@postnewspapers.com.au>
	<20091103235245.GA77360@mr-paradox.net>
	<4AF0C48E.8090100@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4AF0C48E.8090100@gmail.com>
User-Agent: Mutt/1.4.2.3i
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: 200911/36
X-Sequence-Number: 36204

On Wed, Nov 04, 2009 at 11:02:22AM +1100, Chris wrote:
- David Kerr wrote:
- >On Wed, Nov 04, 2009 at 07:43:16AM +0800, Craig Ringer wrote:
- >- David Kerr wrote:
- No.
- 
- This is explained in the notes here:
- 
- http://www.postgresql.org/docs/current/static/sql-prepare.html

<sigh> and i've read that before too.

On the upside, then it behaves like I would expect it to, which is
good.

Thanks

Dave