Forum OpenACS Q&A: Re: Bloating up a view, is it possible?

Collapse
Posted by Jonathan Ellis on
Like Alfred said, there is no copying (tuple updates) preformed when selecting from a view.

I do suspect that PG views aren't very smart about only materializing needed columns in a select but it should be easy to verify.  Create a view with a column that calls a function that does something in a loop a few million times and try it...