Request a Demo
Home   >   mailing lists

REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table - Mailing list pgsql-general

From Dirk Krautschick
Subject REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Date
Msg-id 918deb54-9d01-4a9c-abd3-d8412c9e6c80@gmx.de
Whole thread Raw
Responses Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
List pgsql-general
Tree view
Hi,

I have a situation here where a frequent 

REFRESH MATERIALIZED VIEW CONCURRENTLY

is preventing autovacuum on some tables kind of running into a circle of growing.

Why is this acutally blocking autovacuum and what is the best practice to prevent 
this excelt just not refreshing the materialized view frequently? :-)

Cheers

Dirk

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Table bloat threshold limit to trigger repack
Next
From: Adrian Klaver
Date:
Subject: Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table