On Wed, Nov 25, 2009 at 4:26 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> Richard Neill <rn214(at)cam(dot)ac(dot)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..
In response to
pgsql-performance by date
|Next:||From: Steve Crawford||Date: 2009-11-25 16:45:46|
|Subject: Re: RAID card recommendation|
|Previous:||From: Kevin Grittner||Date: 2009-11-25 16:26:15|
|Subject: Re: Query times change by orders of magnitude as DB ages|