Re: Shipping big WAL archives to hot standby

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: Shipping big WAL archives to hot standby
Дата
Msg-id CAEyp7J8rnbdJxP=O_rOWxp1bU8GrEf80+tov-QLiaEmtQ9drOw@mail.gmail.com
обсуждение исходный текст
Ответ на Shipping big WAL archives to hot standby  (Jordi <jmaillists@promani.be>)
Список pgsql-general
Дерево обсуждения

What would be the effect of suddenly introducing a 1-2 GB of WAL archives to the WAL restore folder on the slave? Would there be a big performance effect on the incoming queries to the slave? Would the slave be available for queries while the WAL logs are restored into the DB?

If the Queries are running on slave whilst WAL archives are being applied, there is a bright chance that, queries would encounter a conflict with the recovery and would eventually get cancelled. You can see messages in the PostgreSQL logfiles. The recommended approach would be to apply WALs when queries are being executed on slave.

Regards,
Venkata B N

Fujitsu Australia 

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Bypassing NULL elements in row_to_json function
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Really unique session ID - PID + connection timestamp?