Re: parameterized LIKE does not use index - Mailing list pgsql-performance

From Josh Berkus
Subject Re: parameterized LIKE does not use index
Date
Msg-id 200506231155.36126.josh@agliodbs.com
Whole thread Raw
In response to Re: parameterized LIKE does not use index  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: parameterized LIKE does not use index
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Tuning Article
Next
From: Bricklen Anderson
Date:
Subject: ETL optimization