Re: very slow after a while...

On Wed, 06 Apr 2005 14:07:36 +0100
Richard Huxton <dev(at)archonet(dot)com> wrote:

> Costin Manda wrote:
> > I think I found the problem. I was comparing wrongly some values and
> > based on that, every time the script was run (that means once every 5
> > minutes) my script deleted two tables and populated them with about 70
> > thousand records.

> I'm not sure I understand what you're saying, but if you vacuum at the
> wrong time that can cause problems. I've shot myself in the foot before
> now doing something like:
>
> DELETE FROM big_table
> VACUUM ANALYSE big_table
> COPY lots of rows into big_table
>
> Of course, the planner now thinks there are zero rows in big_table.

I mean from 5 to 5 minutes
DROP TABLE
CREATE TABLE
INSERT 70000 rows in table

and the Vacuuming is done at 2 in the morning, there should be no
activity then...