TODO: Cache most recent query plan
От | Karel Zak - Zakkr |
---|---|
Тема | TODO: Cache most recent query plan |
Дата | |
Msg-id | Pine.LNX.3.96.1000216131111.28508B-100000@ara.zf.jcu.cz обсуждение исходный текст |
Список | pgsql-hackers |
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) -----------------------------------------------------------------------
В списке pgsql-hackers по дате отправления: