Re: View vs. direct Table access

I am not to sure about Postgres. I just quoted the SQL standard on views.

Although judging from the ones i use and there relative slow speed i do
not think Postgres caches them in any way

Please Correct me if i am wrong

Thanks

Darren Ferguson

On Wed, 27 Mar 2002, Marin Dimitrov wrote:

>
> ----- 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. "
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>