От: Andy Colson
Тема: Re: High load,
Дата: ,
Msg-id: 4D41A952.3000900@squeakycode.net
(см: обсуждение, исходный текст)
Ответ на: Re: High load,  (Michael Kohl)
Ответы: Re: High load,  (Scott Marlowe)
Список: pgsql-performance

Скрыть дерево обсуждения

High load,  (Michael Kohl, )
 Re: High load,  (Cédric Villemain, )
  Re: High load,  (Michael Kohl, )
   Re: High load,  (Cédric Villemain, )
   Re: High load,  (Jignesh Shah, )
  Re: High load,  (Andres Freund, )
   Re: High load,  (Cédric Villemain, )
    Re: High load,  (Andres Freund, )
 Re: High load,  (Michael Kohl, )
 Re: High load,  (Justin Pitts, )
 Re: High load,  (Andy Colson, )
  Re: High load,  (Michael Kohl, )
   Re: High load,  (Scott Marlowe, )
    Re: High load,  (Michael Kohl, )
     Re: High load,  (Mladen Gogala, )
   Re: High load,  (Andy Colson, )
    Re: High load,  (Scott Marlowe, )
 Re: High load,  (Stephen Frost, )
  Re: High load,  (Scott Marlowe, )
   Re: High load,  (Andres Freund, )
 Re: High load,  ("Ing. Marcos Ortiz Valmaseda", )
 Re: High load,  (Ivan Voras, )
 Re: High load,  (Robert Haas, )
 Re: High load,  (Greg Smith, )

On 1/27/2011 9:09 AM, Michael Kohl wrote:
> On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<>  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 по дате сообщения:

От: Robert Schnabel
Дата:
Сообщение: How to best use 32 15k.7 300GB drives?
От: david@lang.hm
Дата:
Сообщение: Re: How to best use 32 15k.7 300GB drives?