| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | "Naveen Babu (dot)G" <naveen_g(at)students(dot)iiit(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Regarding PostgreSQL Doubt |
| Date: | 2003-09-03 22:29:59 |
| Message-ID: | Pine.LNX.4.21.0309040827260.10282-100000@linuxworld.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 3 Sep 2003, Alvaro Herrera wrote:
> On Wed, Sep 03, 2003 at 06:18:40PM +1000, Gavin Sherry wrote:
>
> > As for materialised views, I cannot recall any discussion of this in the
> > recent past.
>
> Sorry, what is a materialized view? Is it something that you can do
> with CREATE TABLE AS, or it is more involved than that?
Under Oracle, materialised views can be regularly updated when view base
tables are updated. They're very useful for datawarehousing and reporting,
particularly on large data sets.
Though useful, they would be far from trivial to implement in Postgres.
g
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-03 22:35:44 | Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...) |
| Previous Message | Peter Eisentraut | 2003-09-03 22:08:22 | Re: compile warnings in CVS HEAD? |