Re: parameterized LIKE does not use index

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: parameterized LIKE does not use index
Дата
Msg-id 200506231155.36126.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: parameterized LIKE does not use index  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: parameterized LIKE does not use index
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance Tuning Article
Следующее
От: Bricklen Anderson
Дата:
Сообщение: ETL optimization