Where is the generic plan stored when using PREPARE statement?

From: Zhan Li <zhanli89(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Where is the generic plan stored when using PREPARE statement?
Date: 2014-02-11 15:55:10
Message-ID: CANp-BfYZi_GSB2T3=Cr8vBv84BS8io_UimSvEkbLR9gRL1-fAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message J.F. Oster 2014-02-11 15:56:02 PATCH: Enable deselecting in SQL Grid
Previous Message Dave Page 2014-02-11 15:02:02 pgAgent commit: Bump the version number to 3.4.0.