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.
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 | Number of simultaneous requests that can be handled efficiently by the disk subsystem. |
| Data type | integer |
| Default value | 16 |
| Allowed values | 0-1000 |
| Parameter type | dynamic |
| Documentation | effective_io_concurrency |
file_copy_method
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Selects the file copy method. |
| Data type | enumeration |
| Default value | COPY |
| Allowed values | COPY |
| Parameter type | read-only |
| Documentation | file_copy_method |
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 | 16 |
| Allowed values | 16 |
| Parameter type | read-only |
| Documentation | maintenance_io_concurrency |
max_notify_queue_pages
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of allocated pages for NOTIFY / LISTEN queue. |
| Data type | integer |
| Default value | 1048576 |
| Allowed values | 1048576 |
| Parameter type | read-only |
| Documentation | max_notify_queue_pages |
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 parallel workers that can be active at one time. |
| 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 | Maximum number of concurrent worker processes. |
| 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. Should gather nodes also run subplans or just gather tuples?. |
| 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_notify_queue_pages
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Sets the maximum number of allocated pages for NOTIFY / LISTEN queue. |
| Data type | integer |
| Default value | 1048576 |
| Allowed values | 1048576 |
| Parameter type | read-only |
| Documentation | max_notify_queue_pages |
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 that 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 |
old_snapshot_threshold
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-86400 |
| Parameter type | static |
| Documentation | old_snapshot_threshold |
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 |
old_snapshot_threshold
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-86400 |
| Parameter type | static |
| Documentation | old_snapshot_threshold |
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 |
old_snapshot_threshold
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-86400 |
| Parameter type | static |
| Documentation | old_snapshot_threshold |
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 |
old_snapshot_threshold
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-86400 |
| Parameter type | static |
| Documentation | old_snapshot_threshold |
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 |
old_snapshot_threshold
| Attribute | Value |
|---|---|
| Category | Resource Usage / Asynchronous Behavior |
| Description | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-86400 |
| Parameter type | static |
| Documentation | old_snapshot_threshold |
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 |