wal_skip_threshold
When wal_level is minimal and a transaction commits after creating or rewriting a permanent relation, this setting determines how to persist the new data. If the data is smaller than this setting, write it to the WAL log; otherwise, use an fsync of affected files. Depending on the properties of your storage, raising or lowering this value might help if such commits are slowing concurrent transactions. If this value is specified without units, it is taken as kilobytes. The default is two megabytes (2MB).
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- 2048
- category
- Write-Ahead Log / Settings
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- 未知
- lang
- en
- max val
- 2147483647
- metadata version
- 18
- min val
- 0
- name
- wal_skip_threshold
- short desc
- Minimum size of new file to fsync instead of writing WAL.
- source
- pg-settings-source-snapshot
- unit
- kB
- vartype
- integer
版本定义 PG 18
When wal_level is minimal and a transaction commits after creating or rewriting a permanent relation, this setting determines how to persist the new data. If the data is smaller than this setting, write it to the WAL log; otherwise, use an fsync of affected files. Depending on the properties of your storage, raising or lowering this value might help if such commits are slowing concurrent transactions. If this value is specified without units, it is taken as kilobytes. The default is two megabytes (2MB).
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:22845f38f23d5b63d8aa7b50933c3aa02a4a98dd1ff1464c6313d3c0150aba44
正文语言: en · english-manuals:22845f38f23d5b63d8aa7b50933c3aa02a4a98dd1ff1464c6313d3c0150aba44