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

From Costin Manda
Subject Re: very slow after a while...
Date
Msg-id 1504.193.226.119.24.1112790271.squirrel@193.226.119.24
Whole thread Raw
In response to Re: very slow after a while...  ("Costin Manda" <siderite@madnet.ro>)
Responses Re: very slow after a while...  (Richard Huxton <dev@archonet.com>)
List pgsql-general
  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 still don't know why that affected the speed of the database (even
when the script was not running) and how to fix it. I have a script that
vacuums full and reindexes the database every day. Is there something
else I must do?


-------------------------
E-Mail powered by MadNet.
http://www.madnet.ro/


pgsql-general by date:

Previous
From: D A GERM
Date:
Subject: resetting postgres password
Next
From: John DeSoi
Date:
Subject: Re: resetting postgres password