On Nov 8, 2011, at 3:25 PM, Josh Berkus wrote:
>> I'm about 99% sure the answer to that is 'yes'. Are you thinking of
>> having a background scheduler which handles the updating of
>> schedule-driven (instead of trigger-driven) MVs..? Not to try to
>> feature-creep this on you, but you might consider how a new backend
>> process which handles scheduled tasks could be generalized to go beyond
>> handling just MV updates.. :)
>
> No feature-creeping; the two features described will be hard enough.
> Besides, we have pg_agent for that.
Well, there has to be some way to refresh an MV at regular intervals, no?
Best,
David