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

From Venkat Balaji
Subject Re: warm standby - apply wal archives
Date
Msg-id CAFrxt0hbnkGV1t9xzpXNqKNhgiMTWOeAqR-rsrq5b9qpkTRtFg@mail.gmail.com
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
Considering the size of WAL archives = 200GB

Compressing them using gzip (you can use this command in a shell script and place it in archive_command as well) would possibly reduce the size to as low as 10 - 20 GB.

Please let us know the results.

Thanks
Venkat

On Tue, Sep 6, 2011 at 1:03 PM, MirrorX <mirrorx@gmail.com> wrote:
The network bandwidth between the servers is definitely not an issue. What is
bothering me is the big size of the wal archives, which goes up to 200GB per
day and if the standby server will be able to replay all these files. The
argument that; since the master can do it and also do various other tasks at
the same time, and since the secondary is identical to the first, so he
should be able to do that seems valid, so i will give it a try and let you
know about the results. In the meantime if there are any other
ideas/suggestions etc please let me know. thx to all

--
View this message in context: http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archives-tp4770567p4773498.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Torsten Zühlsdorff
Date:
Subject: Re: Query runs in 335ms; function in 100,239ms : date problem?
Next
From: MirrorX
Date:
Subject: Re: warm standby - apply wal archives