Re: Need help to organize database

On Tue, Dec 21, 2004 at 17:50:06 -0500,
  "Frank D. Engel, Jr."  wrote:
> 
> Also, given the amount of data you are talking about, and assuming that 
> you are inserting all of this data in one big lump, you may wish to 
> VACUUM FULL after doing your INSERTs (not after each one,  of course -- 
> after doing all of the INSERTs, or after doing a big chunk of them.  If 
> data is inserted incrementally over a period of time, then just do the 
> VACUUM ANALYZE every so often during that time, and you shouldn't have 
> a problem).

You only need to vacuum after updates or deletes. After mass inserts you
just want to run ANALYSE.