Resource Usage / Asynchronous Behavior
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
maintenance_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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
maintenance_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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
maintenance_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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
maintenance_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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
backend_flush_after
| 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 |
effective_io_concurrency
| 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 |
max_parallel_maintenance_workers
| 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 |
max_parallel_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 |
max_parallel_workers_per_gather
| 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 |
max_worker_processes
| 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 |
parallel_leader_participation
| 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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for