> 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?
In response to
pgsql-performance by date
|Next:||From: Marc Mamin||Date: 2005-05-27 07:40:31|
|Subject: Re: Optimising queries involving unions|
|Previous:||From: Dawid Kuroczko||Date: 2005-05-26 21:23:15|
|Subject: Re: slow queries, possibly disk io|