This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | A variant of effective_io_concurrency that is used for maintenance work. |
| Data type | integer |
| Default value | 10 |
| Allowed values | 10 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | parallel_leader_participation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | A variant of effective_io_concurrency that is used for maintenance work. |
| Data type | integer |
| Default value | 10 |
| Allowed values | 10 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | parallel_leader_participation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | A variant of effective_io_concurrency that is used for maintenance work. |
| Data type | integer |
| Default value | 10 |
| Allowed values | 10 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | parallel_leader_participation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | A variant of effective_io_concurrency that is used for maintenance work. |
| Data type | integer |
| Default value | 10 |
| Allowed values | 10 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | parallel_leader_participation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | A variant of effective_io_concurrency that is used for maintenance work. |
| Data type | integer |
| Default value | 10 |
| Allowed values | 10 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Number of pages after which previously performed writes are flushed to disk. |
| Data type | integer |
| Default value | 256 |
| Allowed values | 0-256 |
| Parameter type | dynamic |
| Documentation | backend_flush_after |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the number of concurrent disk I/O operations that PostgreSQL expects can be executed simultaneously. |
| Data type | integer |
| Default value | 1 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per maintenance operation. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-64 |
| Parameter type | dynamic |
| Documentation | max_parallel_maintenance_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of workers than can be supported for parallel operations. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of parallel processes per executor node. |
| Data type | integer |
| Default value | 2 |
| Allowed values | 0-1024 |
| Parameter type | dynamic |
| Documentation | max_parallel_workers_per_gather |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of background processes that the system can support. |
| Data type | integer |
| Default value | 8 |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_worker_processes |
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Controls whether Gather and Gather Merge also run subplans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation |
Documentation
Query Tuning / Planner Cost Constants server parameters for Azure Database for PostgreSQL flexible server.
Query Tuning / Genetic Query Optimizer server parameters for Azure Database for PostgreSQL flexible server.
Reporting and Logging / What to Log server parameters for Azure Database for PostgreSQL flexible server.
Training
Module
Understand concurrency in PostgreSQL - Training
Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts. For this reason, it's important to understand the concurrency systems that are in place in Azure Database for PostgreSQL to manage concurrency and conflicts. In this module, we look at both isolation levels and locking
Events