On Fri, Sep 14, 2012 at 1:47 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > 2012/9/14 John R Pierce <pierce@xxxxxxxxxxxx>: >> On 09/13/12 10:17 PM, Wells Oliver wrote: >>> >>> Do these tend to perform well? I have some simple formulas in functions >>> like so: >> >> >> if you code your function in SQL instead of plpgsql, and mark it immutable, >> it can be inlined by the planner. > > you don't need to mark SQL functions - it is not black box for > optimizer and usually better is don't mark SQL functions. on my workstation: OP's plpgsql: 63us / call 1-line plpgsql: 43us / call 1-line sql: 38us / call (marking didn't appear to matter in this case) manually inlined sql: 38us/call query was tested via: explain analyze select stat_foo(v,v,v) from generate_series(1,100000) v; merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
