On Mon, May 19, 2014 at 6:47 AM, Tim Kane <tim.kane@xxxxxxxxx> 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
