"Michael L. Hostbaek" <mich@the-lab.org> 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