Postgres Pro
Downloads
Home   >   mailing lists

Re: Precompile SQL functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Precompile SQL functions
Date
Msg-id 3601.1047097455@sss.pgh.pa.us
Whole thread Raw
In response to Precompile SQL functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Precompile SQL functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Do we precompile SQL functions yet?

As of CVS tip, we can inline SQL functions that are simple "SELECT
expression" cases; and it's always been true that SQL function queries
are planned only once per outer query.  I don't believe there's any
cross-query caching of SQL function plans, however.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [GENERAL] problems with dropped columns
Next
From: Bruce Momjian
Date:
Subject: Re: Precompile SQL functions