Re: DRBD and Postgres: how to improve the perfomance?

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: DRBD and Postgres: how to improve the perfomance?
Дата
Msg-id 2C070D1C3970467FF64F6B6A@imhotep.credativ.de
обсуждение исходный текст
Ответ на DRBD and Postgres: how to improve the perfomance?  (Maila Fatticcioni <mfatticcioni@mbigroup.it>)
Ответы Re: DRBD and Postgres: how to improve the perfomance?  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
--On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs
<simon@2ndquadrant.com> wrote:

> On Fri, 2007-09-07 at 11:37 +0200, Maila Fatticcioni wrote:
>
>>  protocol C;
>
> Try protocol B instead.

But that would have an impact on transaction safety, wouldn't it? It will
return immediately after reaching the remote buffer cache and you can't be
sure your data hits the remote disk.
It's a while ago i've played with such a setup, but it could be worth to
play around with max_buffers, al-extends, snd-bufsize. Oh and i think
Maila's 'rate' setting is too high: i've found rate settings
counterproductive when set too high (try a value slightly above your max
bandwidth of your connection). But i second Heikki, you should take care on
your disk setup as well.

--
  Thanks

                    Bernd

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: SAN vs Internal Disks
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: DRBD and Postgres: how to improve the perfomance?