[PERFORM] view columns and performance

2010-07-30 Thread Eric Schwarzenbach
I'm wondering whether columns, in the select list of a view that is used in a join, which are not used either as join criteria or in the select list of the overall query, effect the performance of the query. In other words supposed I define a view something like CREATE view MyView AS SELECT

Re: [PERFORM] view columns and performance

2010-07-30 Thread Tom Lane
Eric Schwarzenbach subscri...@blackbrook.org writes: I'm wondering whether columns, in the select list of a view that is used in a join, which are not used either as join criteria or in the select list of the overall query, effect the performance of the query. If the view gets flattened into