Re: Need help to organize database

On Tue, Dec 21, 2004 at 17:50:06 -0500,
  "Frank D. Engel, Jr." <fde101@fjrhome.net> 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.