On Fri, 2006-12-01 at 01:05 +0100, Tobias Brox wrote: > > However, we still are suffering a gradual decrease in performance over > > time - or so the application engineers claim. The DBA and I have been > > banging our heads against this for a month. > > We're having the same issues, so we do the dumping and restoring every > now and then to be sure everything is properly cleaned up. With 8.1. > What's causing that? Is it index bloat? I would think a REINDEX would avoid having to dump/restore, right? A CLUSTER might also be necessary, depending on what kind of performance degradation you're experiencing. Am I missing something? Regards, Jeff Davis
