On Tue, Jan 17, 2006 at 09:17:41PM -0800, kishore.sainath@xxxxxxxxx wrote: > I haven't vacuum/analysed the D2 database or for that matter D1. > In fact I have never used VACUUM before. > Maybe that is the problem. > > What are the benefits of the VACUUM command in PostgreSQL? See the section on vacuuming in "Routine Database Maintenance Tasks" in the documentation: http://www.postgresql.org/docs/7.3/interactive/routine-vacuuming.html -- Michael Fuhr
