On 5/26/05, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > I have some queries that have significan't slowed down in the last > > couple days. It's gone from 10 seconds to over 2 mins. > > > > The cpu has never gone over 35% in the servers lifetime, but the load > > average is over 8.0 right now. I'm assuming this is probably due to > > disk io. > > You sure it's not a severe lack of vacuuming that's the problem? >
It's vacuumed hourly. If it needs to be more than that I could do it I guess. But from everything I've been told, hourly should be enough. -Josh ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend