Re: PREPARE / EXECUTE

Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> I wonder if there is a way to store a parsed/rewritten/planned query in 
> a table so that it can be loaded again.

The original version of the PREPARE patch used a shared-across-backends
cache for PREPAREd statements.  We rejected that for a number of
reasons, one being the increased difficulty of keeping such a cache up
to date.  I think actually storing the plans on disk would have all the
same problems, but worse.
        regards, tom lane