Re: High load,

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: High load,