Re: very slow after a while...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Costin Manda <siderite(at)madnet(dot)ro>, pgsql-general(at)postgresql(dot)org
Subject: Re: very slow after a while...
Date: 2005-04-06 16:59:28
Message-ID: 28287.1112806768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ragnar Hafstað 2005-04-06 17:01:07 Re: very slow after a while...
Previous Message Tom Lane 2005-04-06 16:57:18 Re: Big trouble with memory !!