Re: High load, - Mailing list pgsql-performance

From Andy Colson
Subject Re: High load,
Date
Msg-id 4D41A952.3000900@squeakycode.net
Whole thread Raw
In response to Re: High load,  (Michael Kohl <michael.kohl@tupalo.com>)
Responses Re: High load,  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
Next
From: Stephen Frost
Date:
Subject: Re: High load,