Re: Materialized views

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