Re: Need a depth information about bloat

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Rama Krishnan <raghuldrag(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need a depth information about bloat
Date: 2020-08-10 04:17:53
Message-ID: D41C40D5-5CBF-4658-B067-FEB2CB401A58@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 9, 2020, at 9:01 PM, Rama Krishnan <raghuldrag(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rama Krishnan 2020-08-10 04:19:51 Re: Need a depth information about bloat
Previous Message Adrian Klaver 2020-08-10 04:17:38 Re: Need a depth information about bloat