pgsql: Treat negative values of recovery_min_apply_delay as having no e

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Treat negative values of recovery_min_apply_delay as having no e
Дата
Msg-id E1Y7TDQ-00056m-Vq@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Treat negative values of recovery_min_apply_delay as having no effect.

At one point in the development of this feature, it was claimed that
allowing negative values would be useful to compensate for timezone
differences between master and slave servers.  That was based on a mistaken
assumption that commit timestamps are recorded in local time; but of course
they're in UTC.  Nor is a negative apply delay likely to be a sane way of
coping with server clock skew.  However, the committed patch still treated
negative delays as doing something, and the timezone misapprehension
survived in the user documentation as well.

If recovery_min_apply_delay were a proper GUC we'd just set the minimum
allowed value to be zero; but for the moment it seems better to treat
negative settings as if they were zero.

In passing do some extra wordsmithing on the parameter's documentation,
including correcting a second misstatement that the parameter affects
processing of Restore Point records.

Issue noted by Michael Paquier, who also provided the code patch; doc
changes by me.  Back-patch to 9.4 where the feature was introduced.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/e7c1188756c9a57068e6be0c4cf2c448addb8b0c

Modified Files
--------------
doc/src/sgml/recovery-config.sgml |   23 +++++++++++------------
src/backend/access/transam/xlog.c |    2 +-
2 files changed, 12 insertions(+), 13 deletions(-)


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: pgsql: Make path to pg_service.conf absolute in documentation
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Treat negative values of recovery_min_apply_delay as having no e