Postgres Pro
Downloads
Home   >   mailing lists

Re: "View" in server level - Mailing list pgsql-general

From Doug McNaught
Subject Re: "View" in server level
Date
Msg-id m3r8ms0zd9.fsf@varsoon.denali.to
Whole thread Raw
In response to "View" in server level  (謎語人\(Q & A\) <riddler@hkpcug.org>)
List pgsql-general
Tree view 
謎語人\(Q & A\) <riddler@hkpcug.org> writes:

>     At the time I create a "View", the data of the "View" is stored in
> memory, or generated each time while I call it? If it is stored in memory,
> it is stored at HD or Ram?

A view is just a way of magically rewriting queries--nothing is stored
in RAM or on the disk.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

pgsql-general by date:

Previous
From: "Dave"
Date:
Subject: Re: Postgres not starting at boot(FreeBSD) - startup script not releasing < solved
Next
From: Michael Robinton
Date:
Subject: problem with upgrade from 6.5 -> 7.2 (fwd)