From: Merlin Moncure <mmoncure@gmail.com>
To: mfatticcioni@mbigroup.it
Cc: pgsql-performance@postgresql.org
Subject: Re: DRBD and Postgres: how to improve the perfomance?
Date: Fri, 7 Sep 2007 08:56:15 -0400
Message-ID: <b42b73150709070556o22768ba5uc5ce260ebd2b10f2@mail.gmail.com> (raw)
In-Reply-To: <46E11BE4.6060500@mbigroup.it>
References: <46E11BE4.6060500@mbigroup.it>
On 9/7/07, Maila Fatticcioni <mfatticcioni@mbigroup.it> wrote:
> Obviously, working with the database in DRBD, we had two writes instead
> of only one but we are a bit disappointed about the low results. We
> would like to know if there is any way to improve the performance in
> order to have a 3/4 rate instead of the 1/2 one.
Have you considered warm standby PITR? It achieves essentially the
same thing with very little overhead on the master. The only downside
relative to DRDB is you have to think about the small gap between WAL
file rotations. From what I understand, there is some new stuff
(check out skype skytools) that may help minimize this problem.
merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, mfatticcioni@mbigroup.it
Subject: Re: DRBD and Postgres: how to improve the perfomance?
In-Reply-To: <b42b73150709070556o22768ba5uc5ce260ebd2b10f2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox