Type: integer
Défaut: 2048 (2MB)
Min: 0 (0kB)
Max: 2147483647 (2147483647kB)
Unité: KB
Contexte: user
Redémarrer: false
Depuis: 13

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).

Commentaires