| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Frank D(dot) Engel, Jr(dot)" <fde101(at)fjrhome(dot)net> |
| Cc: | General PostgreSQL list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Need help to organize database |
| Date: | 2004-12-22 03:27:47 |
| Message-ID: | 20041222032747.GB24372@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 21, 2004 at 17:50:06 -0500,
"Frank D. Engel, Jr." <fde101(at)fjrhome(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Hatcher | 2004-12-22 03:36:01 | Re: DELETE versus TRUNCATE during pg_dump.... |
| Previous Message | Bruno Wolff III | 2004-12-22 03:25:59 | Re: Need help to organize database |