Re: Views- Advantages and Disadvantages

On May 9, 2007, at 19:58 , Joshua D. Drake wrote:

> Brent Wood wrote:
>> Ashish Karalkar wrote:
>>> Thanks Brent for your replay,
>>>
>>>
>>> What about the Disadvantages, Performance issues?
>> As far as I'm aware, performance is the only real disadvantage.
>
> What performance are we talking about here? Executing from a view
> although has *some* overhead, I don't even know that it is worth
> considering in most cases.

Two people now have stated without much qualification that views have
some kind of associated performance (Brent Woods) or optimization
(Dann Corbit) penalty. Where does this idea come from? Views in
PostgreSQL are just rewritten with the view query inlined! There's
not much overhead there AIUI.

Michael Glaesemann
grzm seespotcode net