Re: DRBD and Postgres: how to improve the perfomance? - Mailing list pgsql-performance

From Bernd Helmle
Subject Re: DRBD and Postgres: how to improve the perfomance?
Date
Msg-id 2C070D1C3970467FF64F6B6A@imhotep.credativ.de
Whole thread Raw
In response to DRBD and Postgres: how to improve the perfomance?  (Maila Fatticcioni <mfatticcioni@mbigroup.it>)
Responses Re: DRBD and Postgres: how to improve the perfomance?  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SAN vs Internal Disks
Next
From: Simon Riggs
Date:
Subject: Re: DRBD and Postgres: how to improve the perfomance?