On Sat, Feb 21, 2015 at 1:04 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Robert Haas <robertmh...@gmail.com> writes: >> I'm not really sure what Josh was talking about in that answer. In >> terms of doing this automatically, I doubt that's likely to happen >> until we have a way to automatically update a materialized view when >> the underlying data changes --- and Kevin Grittner has done a bunch of >> work towards that, but more is needed to get us there. > > Even with auto maintenance, it seems unlikely that matviews would ever > be so transparent that it would be okay for the planner to automatically > substitute them into a query. The data in a matview is going to be at > least a little bit stale, else You're Doing It Wrong.
Perhaps, but this is a feature we've gotten MANY customer requests for. IDK why, but it's true. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
