Should a materialized view be based on a view?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Should a materialized view be based on a view?
Date: 2011-11-18 22:26:43
Message-ID: 4EC68743020000250004327B@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I still have a lot of reading to do before I propose anything
concrete for development, but one thing that has already struck me
as a common theme for MVs is that a lot of people seem to like the
idea of first creating a "normal" view, and then materializing it.
That seems pretty attractive to me, too. How do people feel about
that as a fundamental design decision: that a MV would always have
a corresponding view (under a different name or in a different
schema)? Love it or hate it?

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2011-11-18 22:36:31 Re: testing ProcArrayLock patches
Previous Message Andres Freund 2011-11-18 22:12:02 Re: testing ProcArrayLock patches