From: Josh Close <narshe@gmail.com>
To: POSTGRES-PERFORMANCE <pgsql-performance@postgresql.org>
Subject: Re: slow queries, possibly disk io
Date: Fri, 27 May 2005 08:05:47 -0500
Message-ID: <4a0cafe2050527060533d3c4e9@mail.gmail.com> (raw)
In-Reply-To: <42967810.8040700@familyhealth.com.au>
References: <4a0cafe205052613242e0d4d10@mail.gmail.com>
<42967810.8040700@familyhealth.com.au>
On 5/26/05, Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: narshe@gmail.com
Subject: Re: slow queries, possibly disk io
In-Reply-To: <4a0cafe2050527060533d3c4e9@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox