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@xxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
