Thank you for the clarification brother ๐๐ On Mon, 10 Aug, 2020, 09:47 Rob Sargent, <robjsarg...@gmail.com> wrote:
> > > > 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.