Re: warm standby - apply wal archives - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: warm standby - apply wal archives
Date
Msg-id 20110905165338.GA24944@tux
Whole thread Raw
In response to Re: warm standby - apply wal archives  (MirrorX <mirrorx@gmail.com>)
Responses Re: warm standby - apply wal archives
List pgsql-general
MirrorX <mirrorx@gmail.com> wrote:

> my bad...
> i read in the manual that the recovery process is constant and runs all the
> time. so the question now is
> how many wals can this procedure handle? for example can it handle 100-200G

sure, if the master can handle that it's no problem for the client (same
hardware). In my experience it's only a fraction of work for the client
(streaming replication with 9.0)


> every day? if it cannot, any other suggestions for HA ?thx in advance

Depends on your requirements, for instance heartbeat and DRBD is an
other solution.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: MirrorX
Date:
Subject: Re: warm standby - apply wal archives
Next
From: MirrorX
Date:
Subject: Re: warm standby - apply wal archives