On Wed, 31 Oct 2001, Leong, Fushan wrote: > delete them is bad.. but you can not let them grow forever........ > > When and how to clean up these files?
You should VACUUM ANALYZE occasionally depending your rate of updates and deletes on your tables. I think you'll also need to use REINDEX when you want to shrink the index space. I believe there's information about these commands in the admin documentation. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
