On Mon, May 19, 2014 at 6:47 AM, Tim Kane <[email protected]> wrote: > Aside from the convenience of the REFRESH functionality, are there any other > factors I should consider? An exclusive lock is taken on the materialized view during a REFRESH operation, blocking an read or write queries attempted on them. You can tackle this limitation in the upcoming 9.4 by using REFRESH CONCURRENTLY, a unique index being necessary on the materialized view. -- Michael
-- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
