Merlin Moncure <mmonc...@gmail.com> wrote: > #1 issue I have with current matview functionality is locking. > currently refresh takes out an access exclusive lock. so, > question is, do you think your proposal will be such that it will > no longer require taking out full lock for refresh purposes > (either incremental or otherwise)?
The right thread for *that* question is "Differential (transactional) REFRESH"; however, I might as well say here that I don't think we want to get rid of the (faster) version that just replaces the current heap when we add the (slower) option to REFRESH it transactionally. -- Kevin Grittner 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
