Movatterモバイル変換

Enables/disables background garbage collection of compressed pages. Default:on

Number of CFS background garbage collection workers. This parameter can only be set at server start. Default: 1

CFS compression level: 0 — no compression, 1 — maximal speed. Other possible values depend on the specific compression algorithm used. For example, 9 forzlib or 19 forzstd. Default: 1

Minimum percent of garbage blocks in the file required to start garbage collection. If you would like to manually defragment a relation with a smaller percent of garbage, you can temporarily set this parameter to a smaller value for your current session. Default: 50

Time interval between CFS garbage collection iterations, in milliseconds. Default: 5 seconds

When set totrue, compresses temporary tables. For large temporary tables, this setting can save disk space and speed up execution as less data needs to be read. This parameter can only be set at server start. Default:false

Time interval for which garbage collection is paused after each file defragmentation, in milliseconds. Default: 0