Re: WAL shipping with archive_timeout & pg_switch_xlog()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL shipping with archive_timeout & pg_switch_xlog()
Дата
Msg-id 29038.1209050286@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WAL shipping with archive_timeout & pg_switch_xlog()  (wstrzalka <wstrzalka@gmail.com>)
Список pgsql-general
wstrzalka <wstrzalka@gmail.com> writes:
> archive_timeout is used for WAL shipping to standby server in my case
> (are there any other reasons?), but WAL is switched by the timeout
> even if there are no changes on the server.

This is intentional.  Some people consider the arrival of a new WAL file
to be a good heartbeat monitor, and they want to see one go by every
so many seconds whether the database is busy or not.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql and logical expression evaluation
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: [HACKERS] I think this is a BUG?