REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table

From: Dirk Krautschick <dee-kay(at)gmx(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Date: 2026-02-09 01:17:59
Message-ID: 918deb54-9d01-4a9c-abd3-d8412c9e6c80@gmx.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-02-09 01:41:47 Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Previous Message Ron Johnson 2026-02-08 21:06:09 Re: Table bloat threshold limit to trigger repack