TODO: Cache most recent query plan

In TODO is:

CACHE:
* Cache most recent query plan(s) [prepare]

!--> I'm working on this.

TODO.detail (Jan's idea):

I can think of the following construct:

PREPARE optimizable-statement;

That one will run parser/rewrite/planner, create a new memory
context with a unique identifier and saves the querytree's
and plan's in it. Parameter values are identified by the
usual $n notation. The command returns the identifier.

EXECUTE QUERY identifier [value [, ...]];

then get's back the prepared plan and querytree by the id,
creates an executor context with the given values in the
parameter array and calls ExecutorRun() for them.

.... etc (cut).

Karel

----------------------------------------------------------------------
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> http://home.zf.jcu.cz/~zakkr/

Docs: http://docs.linux.cz (big docs archive)
Kim Project: http://home.zf.jcu.cz/~zakkr/kim/ (process manager)
FTP: ftp://ftp2.zf.jcu.cz/users/zakkr/ (C/ncurses/PgSQL)
-----------------------------------------------------------------------