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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs <simon@xxxxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux