Re: Index bloat of 4x - Mailing list pgsql-general

From Tom Lane
Subject Re: Index bloat of 4x
Date
Msg-id 19674.1169104105@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index bloat of 4x  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Index bloat of 4x  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
Bill Moran <wmoran@collaborativefusion.com> writes:
> 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.

Um, no, you had plenty of table *and* index bloat before.  The problem
here is that VACUUM FULL fixed all the table bloat whilst making the
index situation worse :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: datatype advice numeric vs. varchar
Next
From: "James Im"
Date:
Subject: Re: Controlling memory of session