Plan chosen for PQexecParams

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Plan chosen for PQexecParams
Дата
Msg-id 20051120205111.GA55457@winnie.fuhr.org
обсуждение исходный текст
Ответы Re: Plan chosen for PQexecParams  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I've noticed that if a client uses PQexecParams, the query plan
appears to be identical to the plan chosen for PQprepare/PQexecPrepared,
which might not be as optimal as a plan chosen for PQexec.  I can
understand the PQprepare case since the planner doesn't know what
parameters will actually be used, but with PQexecParams shouldn't
the planner have all the information it needs to choose a plan based
on specific parameters?  Is PQexecParams just shorthand for a prepare
followed by an execute?

-- 
Michael Fuhr


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Data directory on read-only media
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Data directory on read-only media