Re: Where is the generic plan stored when using PREPARE statement?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Where is the generic plan stored when using PREPARE statement?
Дата
Msg-id 1392152819.2712.0.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Where is the generic plan stored when using PREPARE statement?  (Zhan Li <zhanli89@gmail.com>)
Список pgadmin-hackers
On Tue, 2014-02-11 at 10:55 -0500, Zhan Li wrote:
> Hi All,
>
> According to the document, if a prepared statement is executed enough
> times, the server may eventually decide to save and re-use a generic plan
> rather than re-planning each time. My question is where the generic plan is
> saved?

In memory. There's actually no reason to put them on disk.

>  Is it stored in a file in disk? If yes, where is it located and what
> is the file name?
>
> Thanks,
> Zhan


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Add CREATE EXTENSION Support
Следующее
От: Dave Page
Дата:
Сообщение: Re: Add CREATE EXTENSION Support