Re: View vs Stored Proc Performance

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

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.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-09-15 15:44:59 Re: disable heavily updated (but small) table auto-vecuuming
Previous Message Ivan Voras 2009-09-15 15:14:06 Re: View vs Stored Proc Performance