Horton

Re: storing binary data

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Joe Conway" <joseph.conway@home.com>, "Jason Orendorff" <jason@jorendorff.com>, pgsql-hackers@postgresql.org
Date: 2001-10-25T02:21:38Z
Lists: pgsql-hackers 
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What exactly is the advantage in using VIEWs?

A level of logical indirection between the application and the physical
data schema.  There are no performance benefits.

> I get the impression that the
> SELECT query it is based on is cached (ie. a cached query plan).

Nope.  If there's something in the docs that makes you think so,
point out so I can fix it ;-)

			regards, tom lane