Forum OpenACS Q&A: Re: Bloating up a view, is it possible?
3: Re: Bloating up a view, is it possible? (response to 1)
Posted by Jonathan Ellis on 10/04/03 06:55 AM
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...