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. Regards Pavel > > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
