Re: View vs Stored Proc Performance - Mailing list pgsql-performance

From Ivan Voras
Subject Re: View vs Stored Proc Performance
Date
Msg-id 9bbcef730909150912q3b24af1dv58f30374be2c60cb@mail.gmail.com
Whole thread Raw
In response to Re: View vs Stored Proc Performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
2009/9/15 Tom Lane <tgl@sss.pgh.pa.us>:
> Ivan Voras <ivoras@freebsd.org> writes:
>> Are functions in language 'sql' handled differently than those of
>> language 'plpgsql'?
>
> Yes.
>
>> I think they're not so in any case a function will behave as a black box
>> with regards to the planner and optimizer (and views are always
>> 'transparent').
>
> No.

Thanks! This is interesting information!

--
f+rEnSIBITAhITAhLR1nM9F4cIs5KJrhbcsVtUIt7K1MhWJy1A==

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: disable heavily updated (but small) table auto-vecuuming
Next
From: Alan McKay
Date:
Subject: statement stats extra load?