Re: A tale of two similar databases - Mailing list pgsql-general

From Michael Fuhr
Subject Re: A tale of two similar databases
Date
Msg-id 20060119224015.GA16152@winnie.fuhr.org
Whole thread Raw
In response to Re: A tale of two similar databases  (kishore.sainath@gmail.com)
List pgsql-general
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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Upgrade Problem: 7.4.3 -> 8.1.2
Next
From: Vishal Dixit
Date:
Subject: Re: pg_dump throws no buffer space available error