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, else you risk losing data. http://www.postgresql.org/docs/8.1/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
