On Thu, Dec 11, 2003 at 15:26:56 -0800,
Matt Gordon <m(dot)gordon(at)f5(dot)com> wrote:
> If I have a table that I only use for INSERTs and queries (no UPDATEs or DELETEs), is it enough to just run ANALYZE on the table instead of VACUUM ANALYZE? In other words, is running a VACUUM on a table useful if all that you're doing is INSERTing into it? My understanding of VACUUM is that it cleans up stale tuples that are left after UPDATEs and DELETEs.
>
You only need to vacuum if you do updates, deletes or when you need to
handle wrap around of transaction IDs (about every 10^9 transactions).