От: Stephen Frost
Тема: Re: High load,
Дата: ,
Msg-id: 20110127175422.GB30352@tamriel.snowman.net
(см: обсуждение, исходный текст)
Ответ на: 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, )

* Michael Kohl () wrote:
> HDD: 2x 120 GB OCZ Vertex 2 SSD; RAID 1

I'm amazed no one else has mentioned this yet, but you should look into
splitting your data and your WALs.  Obviously, having another set of
SSDs to put your WALs on would be ideal.

You should probably also be looking into adjustments to the background
writer.  It sounds like you're getting hit by large checkpoint i/o
(if you turn on logging of that, as someone else suggested, you'll be
able to corrollate the times), which can be helped by increasing the
amount of writing done between checkpoints, so that the checkpoints
aren't as big and painful.  That can be done by making the background
writer more aggressive.

    Thanks,

        Stephen

Вложения

В списке pgsql-performance по дате сообщения:

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