From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Bruno Wolff III <bruno@wolff.to>
Subject: Re: parameterized LIKE does not use index
Date: Thu, 23 Jun 2005 11:55:35 -0700
User-Agent: KMail/1.8
Cc: Kurt De Grave <Kurt.DeGrave@student.kuleuven.ac.be>,
	pgsql-performance@postgresql.org
References: <42BA73CE.4030909@student.kuleuven.ac.be>
	<20050623141854.GA7505@wolff.to>
In-Reply-To: <20050623141854.GA7505@wolff.to>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200506231155.36126.josh@agliodbs.com>

Bruno,

> I remember some discussion about delaying planning until the first
> actual query so that planning could use actual parameters to do
> the planning. If you really want to have it check the parameters
> every time, I think you will need to replan every time. I don't
> know if there is a way to save some of the prepare working while
> doing this.

That wouldn't help much in Kurt's case.    Nor in most "real" cases, which is 
why I think the idea never went anywhere.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco