Re: warm standby - apply wal archives

Поиск
Список
Период
Сортировка
От Venkat Balaji
Тема Re: warm standby - apply wal archives
Дата
Msg-id CAFrxt0hbnkGV1t9xzpXNqKNhgiMTWOeAqR-rsrq5b9qpkTRtFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: warm standby - apply wal archives  (MirrorX <mirrorx@gmail.com>)
Ответы Re: warm standby - apply wal archives
Список 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 по дате отправления:

Предыдущее
От: Torsten Zühlsdorff
Дата:
Сообщение: Re: Query runs in 335ms; function in 100,239ms : date problem?
Следующее
От: MirrorX
Дата:
Сообщение: Re: warm standby - apply wal archives