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 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