Re: Materialized views - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Materialized views
Date
Msg-id C7E6FA42-D9F9-4DB0-BC9F-EA630B0ED5AF@kineticode.com
Whole thread Raw
In response to Materialized views  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Nov 8, 2011, at 4:23 PM, Josh Berkus wrote:

>> Well, there has to be some way to refresh an MV at regular intervals, no?
>
> For periodic update matviews, yes.  However, Kevin needs only produce
> the command/function call for updating a generic periodic matview.  He
> doesn't need to provide a scheduling utility.  For simple cases, cron works.

Oh, I see. I was assuming it would be automatic-ish, with the declaration of the matview including update interval
information.Could certainly come later, though. 

Best,

David



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Measuring relation free space
Next
From: Josh Berkus
Date:
Subject: Re: Materialized views