Re: Query preparation

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Query preparation
Дата
Msg-id 49E5DD02.2060909@opencloud.com
обсуждение исходный текст
Ответ на Re: Query preparation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Query preparation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
Heikki Linnakangas wrote:

> Does anyone see a problem with caching the result set descriptor
> (RowDescription)? AFAICS it should never change after a statement is
> prepared. If not, I'll polish up and submit the patch.

If you tie it to the existing named statement mechanisms I think that
works. We invalidate the named statement anyway if the parameter types
change, and you want to invalidate any cached row description at the
same time. Schema changes could bite you, but I think they bite named
statements in other ways anyway. (Not sure how far the server-side
efforts to do plan invalidation progressed)

-O

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Query preparation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query preparation