postgres.git / summary / log / commit / refs
commit 463dde8def8befec1e8f1f3c106c1ce1108ad54f
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: Fri Dec 05 09:58:24 2014 +0000
First released in: 9.5.0, 9.4.0
Print wal_log_hints in the rm_desc routing of a parameter-change record.
It was an oversight in the original commit.
Also note in the sample config file that changing wal_log_hints requires a
restart.
Michael Paquier. Backpatch to 9.4, where wal_log_hints was added.
src/backend/access/rmgrdesc/xlogdesc.c | 7 +++++--
src/backend/utils/misc/postgresql.conf.sample | 1 +
2 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/backend/access/rmgrdesc/xlogdesc.c b/src/backend/access/rmgrdesc/xlogdesc.c
index e3d7b6681f3..5b0e3109dca 100644
--- a/src/backend/access/rmgrdesc/xlogdesc.c
+++ b/src/backend/access/rmgrdesc/xlogdesc.c
@@ -117,12 +117,15 @@ xlog_desc(StringInfo buf, uint8 xl_info, char *rec)
}
}
- appendStringInfo(buf, "parameter change: max_connections=%d max_worker_processes=%d max_prepared_xacts=%d max_locks_per_xact=%d wal_level=%s",
+ appendStringInfo(buf, "parameter change: max_connections=%d max_worker_processes=%d "
+ "max_prepared_xacts=%d max_locks_per_xact=%d "
+ "wal_level=%s wal_log_hints=%s",
xlrec.MaxConnections,
xlrec.max_worker_processes,
xlrec.max_prepared_xacts,
xlrec.max_locks_per_xact,
- wal_level_str);
+ wal_level_str,
+ xlrec.wal_log_hints ? "on" : "off");
}
else if (info == XLOG_FPW_CHANGE)
{
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index 8d5bb1961cc..8dfd485e0b9 100644
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -186,6 +186,7 @@
# open_sync
#full_page_writes = on # recover from partial page writes
#wal_log_hints = off # also do full page writes of non-critical updates
+ # (change requires restart)
#wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers
# (change requires restart)
#wal_writer_delay = 200ms # 1-10000 milliseconds
[parent: f3d7077dad94]