Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9306D9FA381 for ; Fri, 7 Sep 2007 18:54:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 00596-06 for ; Fri, 7 Sep 2007 18:54:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from dd1514.kasserver.com (dd1514.kasserver.com [85.13.128.107]) by postgresql.org (Postfix) with ESMTP id 6432A9F95CD for ; Fri, 7 Sep 2007 18:54:15 -0300 (ADT) Received: from [192.168.0.5] (p5089C2DE.dip.t-dialin.net [80.137.194.222]) by dd1514.kasserver.com (Postfix) with ESMTP id C38481EEBB8; Fri, 7 Sep 2007 23:54:12 +0200 (CEST) Date: Fri, 07 Sep 2007 23:54:12 +0200 From: Bernd Helmle To: Simon Riggs , mfatticcioni@mbigroup.it cc: pgsql-performance@postgresql.org Subject: Re: DRBD and Postgres: how to improve the perfomance? Message-ID: <2C070D1C3970467FF64F6B6A@imhotep.credativ.de> X-Mailer: Mulberry/4.0.8 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/140 X-Sequence-Number: 26685 --On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs 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