Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
recovery_prefetch
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Prefetch referenced blocks during recovery. Look ahead in the WAL to find references to uncached data. |
| Data type | enumeration |
| Default value | try |
| Allowed values | try |
| Parameter type | read-only |
| Documentation | recovery_prefetch |
wal_decode_buffer_size
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Buffer size for reading ahead in the WAL during recovery. Maximum distance to read ahead in the WAL to prefetch referenced data blocks. |
| Data type | integer |
| Default value | 524288 |
| Allowed values | 524288 |
| Parameter type | read-only |
| Documentation | wal_decode_buffer_size |
recovery_prefetch
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Prefetch referenced blocks during recovery. |
| Data type | enumeration |
| Default value | try |
| Allowed values | try |
| Parameter type | read-only |
| Documentation | recovery_prefetch |
wal_decode_buffer_size
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Buffer size for reading ahead in the WAL during recovery. |
| Data type | integer |
| Default value | 524288 |
| Allowed values | 524288 |
| Parameter type | read-only |
| Documentation | wal_decode_buffer_size |
recovery_prefetch
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Prefetch referenced blocks during recovery. |
| Data type | enumeration |
| Default value | try |
| Allowed values | try |
| Parameter type | read-only |
| Documentation | recovery_prefetch |
wal_decode_buffer_size
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Buffer size for reading ahead in the WAL during recovery. |
| Data type | integer |
| Default value | 524288 |
| Allowed values | 524288 |
| Parameter type | read-only |
| Documentation | wal_decode_buffer_size |
recovery_prefetch
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Prefetch referenced blocks during recovery. |
| Data type | enumeration |
| Default value | try |
| Allowed values | try |
| Parameter type | read-only |
| Documentation | recovery_prefetch |
wal_decode_buffer_size
| Attribute | Value |
|---|---|
| Category | Write-Ahead Log / Recovery |
| Description | Buffer size for reading ahead in the WAL during recovery. |
| Data type | integer |
| Default value | 524288 |
| Allowed values | 524288 |
| Parameter type | read-only |
| Documentation | wal_decode_buffer_size |
Note
Azure Database for PostgreSQL Flexible Server 14 does not have any server parameter in the 'Write-Ahead Log / Recovery' category.
Note
Azure Database for PostgreSQL Flexible Server 13 does not have any server parameter in the 'Write-Ahead Log / Recovery' category.
Note
Azure Database for PostgreSQL Flexible Server 12 does not have any server parameter in the 'Write-Ahead Log / Recovery' category.
Note
Azure Database for PostgreSQL Flexible Server 11 does not have any server parameter in the 'Write-Ahead Log / Recovery' category.