On Wed, Feb 22, 2017 at 11:13 AM, Jim Nasby <jim.na...@bluetreble.com> wrote: > Certainly easier, but I don't think it'd be better. Matviews really aren't > the same thing as tables. Off-hand (without reviewing the patch), update and > delete counts certainly wouldn't make any sense. "Insert" counts might, in > as much as it's how many rows have been added by refreshes. You'd want a > refresh count too.
Regular REFRESH truncates the view and repopulates it, but REFRESH CONCURRENTLY does inserts, updates, and deletes as needed to adjust the contents. So I think all the same counters that make sense for regular tables are also sensible here. -- 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
