Michael Fuhr <mike@xxxxxxxx> writes: > On Thu, Jan 26, 2006 at 02:35:42PM -0500, Matthew T. O'Connor wrote: >> If you really are just inserting, and never updating or deleting, then you >> will never need to vacuum the table, rather you will just need to ANALYSE >> the table. > That's not quite true; the table must still be vacuumed occasionally > to prevent transaction ID wraparound failure, Also, somebody made a real good point about rolled-back insertions. Even if the only command you ever apply to the table is INSERT, you could still have dead rows in the table if some of those transactions occasionally roll back. regards, tom lane
