Optimizer + bind variables

Поиск
Список
Период
Сортировка
От David Kerr
Тема Optimizer + bind variables
Дата
Msg-id 20091103174729.GA55736@mr-paradox.net
обсуждение исходный текст
Ответы Re: Optimizer + bind variables
Список pgsql-performance
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?

like  if my query was

select * from users (add a bunch of complex joins) where username = 'dave'
vs
select * from users (add a bunch of complex joins) where username = '?'

In oracle they are frequently different.

if it's possible for the plan to be different how can i generate an
xplan for the bind version?

Thanks!

Dave

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Problem with database performance, Debian 4gb ram ?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Problem with database performance, Debian 4gb ram ?