Erwin Ambrosch <ambre@ebutec.com> writes:
> Are Views per default slower than direct table access?
No; they should be pretty much exactly the same (since a view is really
nothing but a macro that gets expanded in-line in the text of a query
that references it).
I speculate that you've got a complex query that is confusing the
planner into making some bad choices, but without more details
--- like a complete example and EXPLAIN output --- it's hard to say.
regards, tom lane
