Re: max fsm pages question - Mailing list pgsql-performance

From Vivek Khera
Subject Re: max fsm pages question
Date
Msg-id 362E0126-A054-4C70-B702-C467A1778D2E@khera.org
Whole thread Raw
In response to Re: max fsm pages question  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
On Jul 8, 2008, at 3:24 PM, Bill Moran wrote:

> If you don't handle this, that table will continue to grow in size on
> the disk, taking up space unnecessarily and probably negatively
> impacting performance.

s/probably/definitely/

Also, if it was #3 on Bill's list, one thing to do is look for index
bloat.  Reindex followed by vacuum might help as well.

As for running VACUUM FULL, I find it sometimes faster to just do a
dump + reload.  A FULL vacuum is really, really, really, extremely,
slow.


pgsql-performance by date:

Previous
From: "achill@matrix"
Date:
Subject: Re: syslog performance when logging big statements
Next
From: Ow Mun Heng
Date:
Subject: Altering a column type - Most efficient way