"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes: > I cron script is being run every night (while very low db activity), > that deletes all rows from the table, and injects a bunch of new data...
You should vacuum in between ... or even better, do the deletion with TRUNCATE. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend