On 2013-09-20 11:05:06 -0400, Stephen Frost wrote: > * Andres Freund (and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
