Re: does refreshing materialized view make the database bloat?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: does refreshing materialized view make the database bloat?
Дата
Msg-id CAKFQuwZoDgrKN-yhQw0vkfoaYyL1z8QCVtd9+Z5AYKJBH2QDxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: does refreshing materialized view make the database bloat?  (jian he <jian.universality@gmail.com>)
Ответы Re: does refreshing materialized view make the database bloat?  (jian he <jian.universality@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sunday, January 15, 2023, jian he <jian.universality@gmail.com> wrote:


Hi,
why the materialized view itself bloats. If no refresh then no bloat right? If fresh then set based delete operation will make materialized view bloat?
I also found the same question online. https://dba.stackexchange.com/questions/219079/bloat-on-materialized-views Unfortunately nobody answered...


The definition of bloat is a deleted row.  Bloat can be reduced by subsequent row insertions.

David J.

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

Предыдущее
От: jian he
Дата:
Сообщение: Re: does refreshing materialized view make the database bloat?
Следующее
От: jian he
Дата:
Сообщение: Re: does refreshing materialized view make the database bloat?