Postgres Pro
Downloads
Home   >   mailing lists

Re: slow queries, possibly disk io - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: slow queries, possibly disk io
Date
Msg-id 42967810.8040700@familyhealth.com.au
Whole thread Raw
In response to slow queries, possibly disk io  (Josh Close <narshe@gmail.com>)
Responses Re: slow queries, possibly disk io  (Josh Close <narshe@gmail.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: slow queries, possibly disk io
Next
From: "Marc Mamin"
Date:
Subject: Re: Optimising queries involving unions