On 6/29/07, Jan Danielsson <jan.m.danielsson@xxxxxxxxx> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hello all, In order to speed up commonly used queries, I use prepared statements. I assume that 'prepare' tells some database query planner to take a look at a query, and do all preparations for it, then store those preparations somewhere for when it's needed. When I use CREATE FUNCTION to create a function, does that also get "planned" automatically (plsql, specifically). My gut feeling is that it doesn't (mainly since it can be any external language).
by the way, query plans are exposed through spi interface so all pl languages have ability to store plans. pl/sql saves plans as well as static sql in pl/pgsql. ymmv on various other pls. merlin
