Where is the generic plan stored when using PREPARE statement?

Поиск
Список
Период
Сортировка
От Zhan Li
Тема Where is the generic plan stored when using PREPARE statement?
Дата
Msg-id CANp-BfYZi_GSB2T3=Cr8vBv84BS8io_UimSvEkbLR9gRL1-fAg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Where is the generic plan stored when using PREPARE statement?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-hackers
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? Is it stored in a file in disk? If yes, where is it located and what is the file name?

Thanks,
Zhan

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

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAgent commit: Bump the version number to 3.4.0.
Следующее
От: "J.F. Oster"
Дата:
Сообщение: PATCH: Enable deselecting in SQL Grid