我在postgresql.conf 里配置了 full_page_writes 是 on,在gsql查询full_page_writes 也是on, 但是查看控制文件,full_page_writes 是 off,这是怎么回事? 这种情况 full_page_writes 到底是on还是off?
[postgres@pg_155 hadb-opengauss]$ gsql -p31001 -r gsql ((openGauss 3.0.0 build b592536d) compiled at 2022-04-06 17:04:16 commit 0 last mr debug) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help.
openGauss=# show full_page_writes; full_page_writes ------------------ on (1 row)
openGauss=# \q [postgres@pg_155 hadb-opengauss]$ pg_controldata _pg_root/ pg_control version number: 923 Catalog version number: 201611171 Database system identifier: 5932367226362680248 Database cluster state: in production pg_control last modified: Thu 07 Apr 2022 03:06:38 PM CST Latest checkpoint location: 0/23D35C0 Prior checkpoint location: 0/23D34A0 Latest checkpoint's REDO location: 0/23D3540 Latest checkpoint's TimeLineID: 1 Latest checkpoint's full_page_writes: off Latest checkpoint's NextXID: 14081 Latest checkpoint's NextOID: 24576
新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn