> > > 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 ;)
If it did make a difference, you probably want to check the values for your freespace map size. If there's not enough space in the freespace map, vacuum won't be able to properly deal with the indexes so this can happen. (running a database wide vacuum verbose should tell you what values you have vs what values you need) > 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. Good point. (assuming you don't backup different servers around the clock for some reason) //Magnus ------------------------------------------------------------------------- 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
