Re: Materialized views - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Materialized views
Date
Msg-id 4EB9BA5A.3050202@agliodbs.com
Whole thread Raw
In response to Re: Materialized views  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Materialized views
Re: Materialized views
List pgsql-hackers
> 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.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Materialized views
Next
From: Tom Lane
Date:
Subject: Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend