Re: Cached Query Plans

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cached Query Plans
Дата
Msg-id 18717.1207955847@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cached Query Plans  (PFC <lists@peufeu.com>)
Список pgsql-hackers
PFC <lists@peufeu.com> writes:
>     And it is very easy to recognize a query we've seen before,

It's not so easy as all that.  Consider search_path.  Consider temp
tables.

The real problem here is entirely on the client side:

>     But, using prepared statements with persistent connections is messy,  
> because you never know if the connection is new or not,

If you were to fix *that* then both this problem and others (such as
setting up desired SET-parameter values) would go away.
        regards, tom lane


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

Предыдущее
От: PFC
Дата:
Сообщение: Re: Cached Query Plans
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Cached Query Plans