Re: High load,

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Michael Kohl <michael(dot)kohl(at)tupalo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: High load,
Date: 2011-01-27 17:20:18
Message-ID: 4D41A952.3000900@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 1/27/2011 9:09 AM, Michael Kohl wrote:
> On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy(at)squeakycode(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Frost 2011-01-27 17:54:22 Re: High load,
Previous Message Bruce Momjian 2011-01-27 17:07:40 Re: Running PostgreSQL as fast as possible no matter the consequences