From: Scott Marlowe <scott.marlowe@gmail.com>
To: Renato Oliveira <renato.oliveira@grant.co.uk>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Migrate postgres to newer hardware
Date: Wed, 31 Mar 2010 02:11:00 -0600
Message-ID: <r2kdcc563d11003310111h7a0b742av18ff953d33d2d6ea@mail.gmail.com> (raw)
In-Reply-To: <7965A9DCF12CC14984420BCC37B1608F25AB1AEF03@Elzar.grant.co.uk>
References: <7965A9DCF12CC14984420BCC37B1608F25AB1AED49@Elzar.grant.co.uk>
<1269959369.15416.5.camel@deimos>
<20100330143831.GE17567@easy5.in-chemnitz.de>
<7965A9DCF12CC14984420BCC37B1608F25AB1AEE54@Elzar.grant.co.uk>
<4BB22F64.8080708@2ndquadrant.com>
<7965A9DCF12CC14984420BCC37B1608F25AB1AEF03@Elzar.grant.co.uk>
On Wed, Mar 31, 2010 at 1:43 AM, Renato Oliveira
<renato.oliveira@grant.co.uk> wrote:
> Greg,
>
> Thank you very much for your input.
> I agree with you and I do understand where you are coming from.
>
> I do agree that in order to transition without a noticeable downtime the application would need to be built for that.
>
> Which one works best: bucardo, slony or Londiste?
>
> I have researched Slony and Bucardo but have not heard of Londiste before.
>
> How many people are using all three of them and their review have you heard anything about that?
I run slony. On our regular db there are about 2000 relations, about
1200 of those are indexes, so slony has to worry about 800 or so
relations. It has no problem with that. On another machine that has
some 45k relations in addition to the 2000 base relations. That slony
instance takes 3.5 hours to run the same create set that takes 2
minutes on the machine with just 2000 relations.
Slony should be able to work for you. See if you can schedule it so
you start your subscription right when you're entering your lowest
throughput window. Your real bottleneck here is that source database
with a single hard drive. That's going to limit your speed of
subscription by quite a bit.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, renato.oliveira@grant.co.uk, greg@2ndquadrant.com, postgresql@tisc.de
Subject: Re: Migrate postgres to newer hardware
In-Reply-To: <r2kdcc563d11003310111h7a0b742av18ff953d33d2d6ea@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