Re: High load,

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: High load,
Дата
Msg-id 20110127175422.GB30352@tamriel.snowman.net
обсуждение исходный текст
Ответ на High load,  (Michael Kohl <michael.kohl@tupalo.com>)
Ответы Re: High load,  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
* Michael Kohl (michael.kohl@tupalo.com) 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: High load,
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: High load,