> On Aug 9, 2020, at 9:01 PM, Rama Krishnan <raghuld...@gmail.com> wrote:
>
>
> Hi Mentors,
>
>
> I am searching for an understanding of bloat in PostgreSQL
>
> What is bloat?
>
> How does it work?
>
> What is the use of bloat?
>
> Limitations of bloat?
>
> Thanks
>
> Rama Krishnan
Bloat is not a feature of postgreSQL, it’s a consequence. It has no redeeming
value.
Updates to tuples generally cause a new tuples to be constructed and the
original to be marked as disposable. It is the job of the vacuum process to rid
the table of this record. Until this happens the marked record as part of the
bloat for that table.
