DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=IqpmH+ledD33OhEZd0mFXcs3nPUvJ9oJI5VSA21vSuAkFKoOqQ2dcWGKJfmNMv8myM
	n/WIaEcB/gqb2A0uj/idJwLc9/dUjtXhVwgqL0zcAo0LkUiaxrCxYS7XWqZzeJqE9dei
	LV2s8h4sQhNyU8BWgXy9n5Yv+lHH9vWEKAeow=
Message-ID: <4AF0C48E.8090100@gmail.com>
Date: Wed, 04 Nov 2009 11:02:22 +1100
From: Chris <dmagick@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: David Kerr <dmk@mr-paradox.net>
CC: Craig Ringer <craig@postnewspapers.com.au>,
	pgsql-performance@postgresql.org
Subject: Re: Optimizer + bind variables
References: <20091103174729.GA55736@mr-paradox.net>
	<4AF0C014.4090000@postnewspapers.com.au>
	<20091103235245.GA77360@mr-paradox.net>
In-Reply-To: <20091103235245.GA77360@mr-paradox.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

David Kerr wrote:
> On Wed, Nov 04, 2009 at 07:43:16AM +0800, Craig Ringer wrote:
> - David Kerr wrote:
> - > Does/is it possible for the PG optimizer come up with differnet plans when 
> - > you're using bind variables vs when you send static values?
> - 
> - Yes, if the bind variable form causes your DB access driver to use a
> - server-side prepared statement. Pg can't use its statistics to improve
> - its query planning if it doesn't have a value for a parameter when it's
> - building the query plan.
> 
> hmm, that's a little unclear to me.
> 
> let's assume that the application is using prepare:
> 
> Assuming the database hasn't changed, would:
> PREPARE bla1 as SELECT * from users where username = '$1';
> explain execute bla1
> 
> give the same output as
> explain select * from users where username = 'dave';
> 
> ?

No.

This is explained in the notes here:

http://www.postgresql.org/docs/current/static/sql-prepare.html

-- 
Postgresql & php tutorials
http://www.designmagick.com/