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

From Tom Lane
Subject Re: View vs Stored Proc Performance
Date
Msg-id 12712.1253028373@sss.pgh.pa.us
Whole thread Raw
In response to Re: View vs Stored Proc Performance  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: View vs Stored Proc Performance  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: View vs Stored Proc Performance
Next
From: Robert Haas
Date:
Subject: Re: disable heavily updated (but small) table auto-vecuuming