Re: A tale of two similar databases

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