[Jeff Davis - Thu at 04:57:54PM -0800] > > 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? Just as with Paul Lathrops case, the performance degradation is something perceived by the application developers. We haven't had time to actually verify reliably that the performance is actually beeing degraded, neither that the reload beeing done helps (after we resolved the pending transaction issue, anyway), nor look into what the possible reasons of this percieved degradation could be.
