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@gmail.com