On Thu, Sep 24, 2020 at 6:55 AM Guillaume Luchet <g.luc...@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 something someone 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
