Justin Pryzby <pryzby@xxxxxxxxxxxxx> writes: > On Fri, May 07, 2021 at 05:57:19PM +0200, Semen Yefimenko wrote: >> For testing purposes I set up a separate postgres 13.2 instance on windows. >> To my surprise, it works perfectly fine. Also indexes, have about 1/4 of >> the size they had on 12.6. > In pg13, indexes are de-duplicated by default. > But I suspect the performance is better because data was reload, and the > smaller indexes are a small, additional benefit. Index bloat is often a consequence of inadequate vacuuming. You might need to dial up autovacuum's aggressiveness to keep their sizes in check. regards, tom lane
