Re: Index bloat of 4x

In response to Alvaro Herrera <alvherre@commandprompt.com>:

> 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.