Re: Need explanation on index size

2020-09-24 Thread Peter Geoghegan
On Thu, Sep 24, 2020 at 6:55 AM Guillaume Luchet 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

Re: Need explanation on index size

2020-09-24 Thread Chris Sterritt
On 24/09/2020 15:08, Guillaume Lelarge wrote: Hi, Le jeu. 24 sept. 2020 à 15:55, Guillaume Luchet > a écrit : Hi, I’m facing of a comportement I don’t understand on indexes, here a quick example to reproduce my problem test=# select version();

Re: Need explanation on index size

2020-09-24 Thread Guillaume Lelarge
Hi, Le jeu. 24 sept. 2020 à 15:55, Guillaume Luchet a écrit : > Hi, > > I’m facing of a comportement I don’t understand on indexes, here a quick > example to reproduce my problem > > > test=# select version(); > version > > > -

Need explanation on index size

2020-09-24 Thread Guillaume Luchet
Hi, I’m facing of a comportement I don’t understand on indexes, here a quick example to reproduce my problem test=# select version(); version -