Postgres Pro
Downloads
Home   >   mailing lists

Re: does refreshing materialized view make the database bloat? - Mailing list pgsql-general

From David G. Johnston
Subject Re: does refreshing materialized view make the database bloat?
Date
Msg-id CAKFQuwZoDgrKN-yhQw0vkfoaYyL1z8QCVtd9+Z5AYKJBH2QDxQ@mail.gmail.com
Whole thread Raw
In response to Re: does refreshing materialized view make the database bloat?  (jian he <jian.universality@gmail.com>)
Responses Re: does refreshing materialized view make the database bloat?
List pgsql-general
Tree view
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 by date:

Previous
From: jian he
Date:
Subject: Re: does refreshing materialized view make the database bloat?
Next
From: jian he
Date:
Subject: Re: does refreshing materialized view make the database bloat?