On Tue, Jan 17, 2006 at 09:17:41PM -0800, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly