Re: limiting performance impact of wal archiving.

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: limiting performance impact of wal archiving.
Дата
Msg-id 4AF936F3020000250002C4F7@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
Ответы Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
Список pgsql-performance
Laurent Laborde <kerdezixe@gmail.com> wrote:

> BTW, if you have any idea to improve IO performance, i'll happily
> read it.  We're 100% IO bound.

At the risk of stating the obvious, you want to make sure you have
high quality RAID adapters with large battery backed cache configured
to write-back.

If you haven't already done so, you might want to try
elevator=deadline.

> xfs ?

If you use xfs and have the aforementioned BBU cache, be sure to turn
write barriers off.

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: limiting performance impact of wal archiving.
Следующее
От: Laurent Laborde
Дата:
Сообщение: Re: limiting performance impact of wal archiving.