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
