Re: Performance problems - Mailing list pgsql-general

From marco
Subject Re: Performance problems
Date
Msg-id 1051539797.1525.11.camel@rudolf.mpi-halle.mpg.de
Whole thread Raw
In response to Re: Performance problems  (Dennis Gearon <gearond@cvc.net>)
Responses Re: Performance problems
List pgsql-general
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


pgsql-general by date:

Previous
From: David Link
Date:
Subject: Re: pq_recvbuf: unexpected EOF
Next
From: Shridhar Daithankar
Date:
Subject: Re: Estimating space required for indexes