| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Guillaume Luchet <g(dot)luchet(at)bilendi(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need explanation on index size |
| Date: | 2020-09-24 15:41:31 |
| Message-ID: | CAH2-Wz=jfvT1tuk6mq+zuY_dmX0g6emoPN1wC56Jr2f-0+jKhw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 24, 2020 at 6:55 AM Guillaume Luchet <g(dot)luchet(at)bilendi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2020-09-24 21:46:28 | Re: multiple tables got corrupted |
| Previous Message | Chris Sterritt | 2020-09-24 14:22:39 | Re: Need explanation on index size |