Re: GSoC - Materialized Views - is stale or fresh? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: GSoC - Materialized Views - is stale or fresh?
Date
Msg-id 4C1601D30200002500032296@gw.wicourts.gov
Whole thread Raw
In response to Re: GSoC - Materialized Views - is stale or fresh?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: GSoC - Materialized Views - is stale or fresh?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> What Pavel's trying to do here is be smart about figuring out when
> an MV needs to be refreshed.  I'm pretty sure this is the wrong
> way to go about it, but it seems entirely premature considering
> that we don't have a working implementation of a *manually*
> refreshed MV.
Agreed all around.
At the risk of sounding obsessed, this is an area where predicate
locks might be usefully extended, if and when the serializable patch
makes it in.
-Kevin


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: warning message in standby
Next
From: Alvaro Herrera
Date:
Subject: Re: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?