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

--On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs
<simon(at)2ndquadrant(dot)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