Re: View vs. direct Table access

----- Original Message -----
From: "Darren Ferguson"


> The reason the view is slower is because it has to be created first before
> you can select from it.
>
> I.e. every time you select from the view it will have to run the view sql
> before it can select from it
>

could u clarify this? shouldn't some kind of dictionary cache be employed?

this reminds me another issue I couldn't find explained in the docs - does
Postgres have some kind of library cache for sharing/reuse of SQL
statements, pl/pgsql functions, etc?

it seems that there is only buffer cache at present

thanx,

    Marin


----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "