In response to "Magnus Hagander" <[EMAIL PROTECTED]>: > > Also, ensure that you vacuum and analyze PostgreSQL databases > > frequently. > > An occasional REINDEX helps as well. These are normal > > maintenance tasks for PostgreSQL. ANALYZE is especially > > important right after populating a new database. > > REINDEX really shouldn't be needed anymore as long as your database is > properly configured, but if you're still on 7.x it may be.
Shoulda, coulda, woulda. Fact is, in actual experience, doing a REINDEX resulted in both a noticeable reduction in the size of the database, and the appearance of a performance gain. The performance part is arguable, since I didn't do any benchmarking, but it _seemed_ faster ;) But yeah, read the docs. REINDEX shouldn't be needed, but it's there if you want to do it. Plus, on a database that has lots of downtime, like a Bacula system where the backups only run at night, it's not hurting anything to REINDEX during the day. -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
