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 |
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें