Hi Bricklen,
Thanks again for the feedback. The concurrent refresh sounds cool. I just saw the 9.4 release is tentatively scheduled for later this year. Do you know what people have been doing for view refreshes in the meantime?
Thanks
On Tue, Apr 1, 2014 at 11:48 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:
On Wed, Apr 2, 2014 at 1:22 PM, Christopher Jackson <crjackso@xxxxxxxxx> wrote:Yep.
>
> Hi Bricklen,
>
> Thanks for the feedback. I'll play around with materialized views. My
> understanding is they have to be manually triggered for refresh
Re-yep.
> and there's an exclusive lock on the view while the refresh is taking place. Is this
> your understanding as well?
Kevin Grittner has implemented REFRESH MATERIALIZED VIEW CONCURRENTLY
> I'm using PG 9.3.3. If this is true, I'm
> curious what clever ways people have come up with to mitigate any issues
> with the lock.
in 9.4. A unique index is needed on the materialized view as well to
authorize this concurrent operation. It has the merit to allow SELECT
operations on the matview during the refresh.
--
Michael