On Mon, Jan 18, 2010 at 02:43:11PM -0500, Vick Khera wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson <reid.thompson@ateb.com> wrote:
> > Does this max_fsm_pages value seem OK for a 46GB database?
> > I've clustered all the tables that seemed to be exhibiting large amounts
> > of bloat.
>
>
> One more thing you may wish to consider is running re-index on your
> tables. I found that a lot of pages with empty space were compacted
> and the number of fsm entries went down significantly when I did this
> last week. For me this was more important than running cluster to
> pack the data tables themselves.
It was my belief that cluster would re-build the indexes as part of the
cluster operation. Is that belief incorrect?