On Fri, 2003-04-25 at 17:13, Dennis Gearon wrote:
> you need to do vacuum full on a regular basis, like at about the time that
> the select/update times increase by 10-25%. You could put that on
> chron job.
Ok, 'vacuum full' has done the job. It took about an hour to finish, but
in contrast to 'vacuum' access times finally dropped back to a normal
level.
I guess it'll take me some time to find out the optimal "vacuum rate",
but at least it works now :)
Thanks
Marco