Re: Where is the generic plan stored when using PREPARE statement? - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject Re: Where is the generic plan stored when using PREPARE statement?
Date
Msg-id 1392152819.2712.0.camel@localhost.localdomain
Whole thread Raw
In response to Where is the generic plan stored when using PREPARE statement?  (Zhan Li <zhanli89@gmail.com>)
List 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 by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Add CREATE EXTENSION Support
Next
From: Dave Page
Date:
Subject: Re: Add CREATE EXTENSION Support