Re: Performance of pl/pgsql functions? - Mailing list pgsql-general

From John R Pierce
Subject Re: Performance of pl/pgsql functions?
Date
Msg-id 5052CEA5.5040305@hogranch.com
Whole thread Raw
In response to Performance of pl/pgsql functions?  (Wells Oliver <wellsoliver@gmail.com>)
Responses Re: Performance of pl/pgsql functions?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
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.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



pgsql-general by date:

Previous
From: Johan Nel
Date:
Subject: Re: Best free tool for relationship extraction
Next
From: Pavel Stehule
Date:
Subject: Re: Performance of pl/pgsql functions?