NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitc846e67

committed

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 arestart.Michael Paquier. Backpatch to 9.4, where wal_log_hints was added.

1 parentebc2b68 commitc846e67Copy full SHA for c846e67

File tree

2 files changed

-2

lines changed

src/backend
- access/rmgrdesc
  - xlogdesc.c
- utils/misc
  - postgresql.conf.sample

2 files changed

-2

lines changed

`‎src/backend/access/rmgrdesc/xlogdesc.c`

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -108,12 +108,15 @@ xlog_desc(StringInfo buf, XLogReaderState *record)`
`108`	`108`	`}`
`109`	`109`	`}`
`110`	`110`
`111`		`-appendStringInfo(buf,"max_connections=%d max_worker_processes=%d max_prepared_xacts=%d max_locks_per_xact=%d wal_level=%s",`
	`111`	`+appendStringInfo(buf,"max_connections=%d max_worker_processes=%d "`
	`112`	`+"max_prepared_xacts=%d max_locks_per_xact=%d "`
	`113`	`+"wal_level=%s wal_log_hints=%s",`
`112`	`114`	`xlrec.MaxConnections,`
`113`	`115`	`xlrec.max_worker_processes,`
`114`	`116`	`xlrec.max_prepared_xacts,`
`115`	`117`	`xlrec.max_locks_per_xact,`
`116`		`-wal_level_str);`
	`118`	`+wal_level_str,`
	`119`	`+xlrec.wal_log_hints ?"on" :"off");`
`117`	`120`	`}`
`118`	`121`	`elseif (info==XLOG_FPW_CHANGE)`
`119`	`122`	`{`

`‎src/backend/utils/misc/postgresql.conf.sample`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -187,6 +187,7 @@`
`187`	`187`	`# open_sync`
`188`	`188`	`#full_page_writes = on# recover from partial page writes`
`189`	`189`	`#wal_log_hints = off# also do full page writes of non-critical updates`
	`190`	`+# (change requires restart)`
`190`	`191`	`#wal_buffers = -1# min 32kB, -1 sets based on shared_buffers`
`191`	`192`	`# (change requires restart)`
`192`	`193`	`#wal_writer_delay = 200ms# 1-10000 milliseconds`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc846e67

File tree

2 files changed

2 files changed

`‎src/backend/access/rmgrdesc/xlogdesc.c`

`‎src/backend/utils/misc/postgresql.conf.sample`

0 commit comments