Re: Performance of SQL Function versus View - Mailing list pgsql-performance

From Andrew Dunstan
Subject Re: Performance of SQL Function versus View
Date
Msg-id 4F7B0968.5000805@dunslane.net
Whole thread Raw
In response to Re: Performance of SQL Function versus View  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance

On 04/03/2012 10:21 AM, Robert Haas wrote:
>
> You should probably test this in your environment, but I'd expect the
> view to be better.  Wrapping logic inside PL/pgsql functions
> needlessly rarely turn outs to be a win.



Right, But also note that auto_explain is very useful in getting plans
and times of queries nested in functions which can't easily be got
otherwise.

cheers

andrew

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Performance of SQL Function versus View
Next
From: Robert Haas
Date:
Subject: Re: ...WHERE TRUE" condition in union results in bad query pla