On Tue, Jan 17, 2006 at 09:17:41PM -0800, kishore.sainath@gmail.com 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