Re: High load, - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: High load,
Date
Msg-id AANLkTikZzUmbV50CdQnZ-HwkBhywtvJun8a3xN13CFTU@mail.gmail.com
Whole thread Raw
In response to Re: High load,  (Michael Kohl <michael.kohl@tupalo.com>)
Responses Re: High load,  (Michael Kohl <michael.kohl@tupalo.com>)
List pgsql-performance
On Thu, Jan 27, 2011 at 8:09 AM, Michael Kohl <michael.kohl@tupalo.com> 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.

A good method to start is to log long running queries and then explain
analyze just them.

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Postgres 9.0 has a bias against indexes
Next
From: Bruce Momjian
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences