Re: High load,

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: High load,
Дата
Msg-id AANLkTikZzUmbV50CdQnZ-HwkBhywtvJun8a3xN13CFTU@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High load,  (Michael Kohl <michael.kohl@tupalo.com>)
Ответы Re: High load,  (Michael Kohl <michael.kohl@tupalo.com>)
Список 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 по дате отправления:

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Postgres 9.0 has a bias against indexes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences