Re: Performance issue - Mailing list pgsql-sql

From Tom Lane
Subject Re: Performance issue
Date
Msg-id 10459.1083386268@sss.pgh.pa.us
Whole thread Raw
In response to Performance issue  ("Michael L. Hostbaek" <mich@the-lab.org>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: Permissions not working
Next
From: Jeff Eckermann
Date:
Subject: Re: isnumeric() function?