Horton

Re: slow queries, possibly disk io

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Josh Close <narshe@gmail.com>
Cc: pgsql-performance@postgresql.org
Date: 2005-05-27T01:29:52Z
Lists: pgsql-performance 
> 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?

Chris