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