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
valuesin the parameter array and calls ExecutorRun() for them.
.... etc (cut). Karel
----------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.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)
-----------------------------------------------------------------------