In response to Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>: > Bill Moran wrote: > > > The entire database was around 28M prior to the upgrades, etc. Immediately > > after the upgrades, it was ~270M. Following a vacuum full, it dropped to > > 165M. Following a database-wide reindex, it dropped to 30M. > > Oh, so it was clearly the upgrade procedure that caused the bloat ... > Reindexing seems the expected course. Right. Sorry if I didn't explain that properly. It wasn't the fact that it bloated that surprised me. It was the _magnitude_ of bloat that I wasn't expecting, as well as the fact that it was _all_ _index_ bloat. -- Bill Moran Collaborative Fusion Inc.
