Re: PREPARE / EXECUTE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PREPARE / EXECUTE
Дата
Msg-id 1232.1035385334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PREPARE / EXECUTE  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Ответы Re: PREPARE / EXECUTE
Список pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> I wonder if there is a way to store a parsed/rewritten/planned query in 
> a table so that it can be loaded again.

The original version of the PREPARE patch used a shared-across-backends
cache for PREPAREd statements.  We rejected that for a number of
reasons, one being the increased difficulty of keeping such a cache up
to date.  I think actually storing the plans on disk would have all the
same problems, but worse.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Memory leaks
Следующее
От: Hans-Jürgen Schönig
Дата:
Сообщение: Re: PREPARE / EXECUTE