| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance of pl/pgsql functions? |
| Date: | 2012-09-14 06:47:29 |
| Message-ID: | CAFj8pRAdYL1-hCxH+QSZQKHt9YnoaOiGkfX4cNc9mzUTimcs1w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2012/9/14 John R Pierce <pierce(at)hogranch(dot)com>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Hopfgartner | 2012-09-14 09:11:03 | Re: Best free tool for relationship extraction |
| Previous Message | John R Pierce | 2012-09-14 06:28:53 | Re: Performance of pl/pgsql functions? |