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

From Venkat Balaji
Subject Re: warm standby - apply wal archives
Date
Msg-id CAFrxt0jTG+c4fjrSN=XjQWYLSbx1HKJjcHGKpaJ8wxw3bH=pHA@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
In my experience, I had configured a warm standby for 2 TB Postgres Cluster (PostgreSQL 8.4).

Note : I do not know your database size and WAL archive generation rate.

Important considerations i made were as follows -

1. WAL archives transfer from production to standy depends on the network bandwidth (i think you said there is no issue there) and the size of the
    WAL archives.
2. Transfer rate can be optimized by compressing the WAL files. Each WAL file size would reduce to 2 - 3 MB from 16 MB (only in case of warm 
    standby. In streaming replication size would decrease to 7 or 6 MB), which makes huge difference for the network bandwidth.

Compress the WAL archives at the production and transfer & uncompress the WALs on standby.

I did this successfully. 

Hope this helps !

Thanks
Venkat

On Tue, Sep 6, 2011 at 2:57 AM, MirrorX <mirrorx@gmail.com> wrote:
the nodes communicate through 4Gbps ethernet so i dont think there is an
issue there. probably some kind of misconfiguration of DRBD has occured. i
will check on that tommorow. thx a lot :)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archives-tp4770567p4772126.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: "Tomas Vondra"
Date:
Subject: Re: Query runs in 335ms; function in 100,239ms : date problem?
Next
From: MirrorX
Date:
Subject: Re: warm standby - apply wal archives