On Wed, Nov 25, 2009 at 4:26 PM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote:
> Richard Neill <rn...@cam.ac.uk> wrote: > > > In terms of just index bloat, does a regular vacuum help? > > You might want to use the REINDEX command to correct serious index > bloat. A regular vacuum will make dead space available for re-use, > but won't eliminate bloat directly. (If run regularly, it will > prevent bloat.) > > for that reason, it makes sense to actually partition your data - even tho you don't see performance degradation because of data size, but purely because of nature of data. Other way, is to perform regular cluster && reindex - but this blocks relations you are clustering.. -- GJ
