Re: Materialized views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Materialized views
Date: 2011-11-09 00:23:08
Message-ID: 4EB9C7EC.20009@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>> 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?

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.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2011-11-09 00:28:42 Re: Materialized views
Previous Message Greg Smith 2011-11-09 00:19:00 Re: Measuring relation free space