On Thu, Sep 24, 2020 at 6:55 AM Guillaume Luchet <g.luchet@bilendi.com> wrote:
> I don’t understand why after the update where I only update a non indexed column the indexes size is growing. Is it
somethingsomeone can explain ?
If you reduce the table fillfactor then these updates will all be HOT
updates. That will make the table larger initially, but leaving enough
space behind on the same heap pages for successor tuples makes it
possible to use HOT updates.
--
Peter Geoghegan
