On Mon, May 19, 2014 at 6:47 AM, Tim Kane <tim.k...@gmail.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
