REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table

Поиск
Список
Период
Сортировка
От Dirk Krautschick
Тема REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Дата
Msg-id 918deb54-9d01-4a9c-abd3-d8412c9e6c80@gmx.de
обсуждение
Ответы Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table
Список 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

В списке pgsql-general по дате отправления: