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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
