Re: View vs Stored Proc Performance

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: View vs Stored Proc Performance
Date: 2009-09-15 16:12:38
Message-ID: 9bbcef730909150912q3b24af1dv58f30374be2c60cb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2009/9/15 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Ivan Voras <ivoras(at)freebsd(dot)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==

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alan McKay 2009-09-15 18:10:52 statement stats extra load?
Previous Message Robert Haas 2009-09-15 15:44:59 Re: disable heavily updated (but small) table auto-vecuuming