On 02/23/2013 02:49 PM, Derek Perak wrote:
Hi, I would like to learn about how stored procedures are handled in postgres. In particular, I'd like to learn how plpgsql procedures are compiled and stored, and how they (both plpgsql and C procedures) interact with the optimizer during planning. Would appreciate if someone can point out some links to the source code for me to check out.
A brief intro: http://www.postgresql.org/docs/9.2/interactive/plhandler.html A graphical look at the source code: http://www.postgresql.org/developer/backend/ If you click on the index link you get: http://wiki.postgresql.org/wiki/Backend_flowchart
Thanks! Derek
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
