Write-Ahead Log / Checkpoints
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
checkpoint_completion_target
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. |
Data type | numeric |
Default value | 0.9 |
Allowed values | 0-1 |
Parameter type | dynamic |
Documentation | checkpoint_completion_target |
checkpoint_flush_after
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Number of pages after which previously performed writes are flushed to disk. |
Data type | integer |
Default value | 32 |
Allowed values | 32 |
Parameter type | read-only |
Documentation | checkpoint_flush_after |
checkpoint_timeout
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum time between automatic WAL checkpoints, in seconds. The valid range is between 30 seconds and one day. |
Data type | integer |
Default value | 600 |
Allowed values | 30-86400 |
Parameter type | dynamic |
Documentation | checkpoint_timeout |
checkpoint_warning
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Writes a warning message if checkpoints caused by the filling of WAL segment more frequently than this. |
Data type | integer |
Default value | 30 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | checkpoint_warning |
max_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Maximum size to let the WAL grow before triggering automatic checkpoint. |
Data type | integer |
Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values | 32-65536 |
Parameter type | dynamic |
Documentation | max_wal_size |
min_wal_size
Attribute | Value |
---|---|
Category | Write-Ahead Log / Checkpoints |
Description | Sets the minimum size to shrink the WAL to. |
Data type | integer |
Default value | 80 |
Allowed values | 32-2097151 |
Parameter type | dynamic |
Documentation | min_wal_size |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru