Re: very slow after a while... - Mailing list pgsql-general

Richard Huxton <dev@archonet.com> writes:
> Costin Manda wrote:
>> I thought the problem lied with step 4, but now I see that step 3 was
>> the culprit and that , indeed, I did not do drop table, create table but
>> delete from and inserts. I think that recreating these two tables should
>> solve the problem, isn't it?

> Hmm - try TRUNCATE rather than DELETE.

Or VACUUM between deleting and inserting.  But TRUNCATE would be better
if you can do it.

            regards, tom lane