From: Andy Colson <andy@squeakycode.net>
To: Michael Kohl <michael.kohl@tupalo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High load,
Date: Thu, 27 Jan 2011 11:20:18 -0600
Message-ID: <4D41A952.3000900@squeakycode.net> (raw)
In-Reply-To: <AANLkTinO3-Rsf7UO6+mqOwdi2nauKgjgztXn9+D-B9D4@mail.gmail.com>
References: <AANLkTikBFzUKmWcVBz_5GQZeQOWtj7Kfeov=M9TWBOJf@mail.gmail.com>
<4D4189FE.7080608@squeakycode.net>
<AANLkTinO3-Rsf7UO6+mqOwdi2nauKgjgztXn9+D-B9D4@mail.gmail.com>
On 1/27/2011 9:09 AM, Michael Kohl wrote:
> On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy@squeakycode.net> wrote:
>> Have you run each of your queries through explain analyze lately?
>
> A code review including checking of queries is on our agenda.
>
>> You are vacuuming/autovacuuming, correct?
>
> Sure :-)
>
> Thank you,
> Michael
>
Oh, also, when the box is really busy, have you watched vmstat to see if
you start swapping?
-Andy
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: andy@squeakycode.net, michael.kohl@tupalo.com
Subject: Re: High load,
In-Reply-To: <4D41A952.3000900@squeakycode.net>
* 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