About vacuuming - Mailing list pgsql-general

From Peter Peltonen
Subject About vacuuming
Date
Msg-id 20020227171203.F24191@gibraltar.fivetec.com
Whole thread Raw
Responses Re: About vacuuming  (Frank Bax <fbax@sympatico.ca>)
List pgsql-general
Questions regarding PostgreSQL 7.1.3 (if things are different with 7.2 I'd
like to know that too :)

How often one should vacuum his db?

Is vacuum --analyze for just providing information or does it somehow
store it's info for postgresql's use (in other words: should I run it too,
and if so, should I do it before or after the real vacuum?).

Should postmaster be running or not when vacuuming?

Regards,
Peter

pgsql-general by date:

Previous
From: "David Blood"
Date:
Subject: sort mem size
Next
From: Jean-Luc Lachance
Date:
Subject: Re: help with getting index scan