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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Zhan Li <zhanli89(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Where is the generic plan stored when using PREPARE statement?
Date: 2014-02-11 21:06:59
Message-ID: 1392152819.2712.0.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2014-02-12 10:21:44 Re: Add CREATE EXTENSION Support
Previous Message David E. Wheeler 2014-02-11 18:50:51 Re: Add CREATE EXTENSION Support