On 2013-09-20 11:05:06 -0400, Stephen Frost wrote:
> * Andres Freund (andres@2ndquadrant.com) wrote:
> > On 2013-09-20 10:51:46 -0400, Stephen Frost wrote:
> > > I'm trying to figure out why that's a perfectly acceptable solution for
> > > users running views with GROUP BYs, but apparently it isn't sufficient
> > > for mat views?
> >
> > Err, because users wrote a GROUP BY? They haven't (neccessarily) in the
> > cases of the matviews we're talking about?
>
> Sure; my thinking was going back to what Hannu had suggested where we
> have a mechanism to see if the value was updated (using xmin or similar)
> and then update it in the mat view in that case, without actually doing
> a comparison at all.
VACUUM, HOT pruning. Have fun.
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services