Tomasz,
> What happens to view planning - is it performed
> during view creation, or rather each time view is quered?
Each time the view is executed. The only savings in running a view over a
regular query is that the view will have taken care of some reference
expansion and JOIN explication during the CREATE process, but not planning.
Also, views can actually be slower if the view is complex enough that any
query-time parameters cannot be "pushed down" into the view.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
