Quick question - I couldn't find this in the docs:
What exactly is the advantage in using VIEWs? I get the impression that the
SELECT query it is based on is cached (ie. a cached query plan).
But, is this cached between db restarts, between connections, etc. Is it
cached upon the first use of the view for a db instance for a particular
connection, etc?
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Thursday, 25 October 2001 1:00 AM
> To: Joe Conway
> Cc: Jason Orendorff; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] storing binary data
>
>
> Joe Conway <joseph.conway@home.com> writes:
> > I'll take a shot at improving the documentation for bytea. I'm hoping
> > documentation patches are accepted during beta though ;-)
>
> Of course. The only limitation we place during beta is "no new features
> added". I plan to spend a good deal of time on the docs during beta
> myself.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>