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.
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Starts the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Minimum number of tuple inserts, updates, or deletes prior to analyze. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Age at which to autovacuum a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | dynamic |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Multixact age at which to autovacuum a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Time to sleep between autovacuum runs. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Vacuum cost delay in milliseconds, for autovacuum. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Vacuum cost amount available before napping, for autovacuum. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Number of tuple inserts prior to vacuum as a fraction of reltuples. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_max_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum number of tuple updates or deletes prior to vacuum. -1 disables the maximum threshold. |
| Data type | integer |
| Default value | 100000000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_max_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Minimum number of tuple updates or deletes prior to vacuum. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum_worker_slots
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the number of backend slots to allocate for autovacuum workers. |
| Data type | integer |
| Default value | 16 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_worker_slots |
vacuum_max_eager_freeze_failure_rate
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Fraction of pages in a relation vacuum can scan and fail to freeze before disabling eager scanning. A value of 0.0 disables eager scanning and a value of 1.0 will eagerly scan up to 100 percent of the all-visible pages in the relation. If vacuum successfully freezes these pages, the cap is lower than 100 percent, because the goal is to amortize page freezing across multiple vacuums. |
| Data type | numeric |
| Default value | 0.03 |
| Allowed values | 0.0-1.0 |
| Parameter type | dynamic |
| Documentation | vacuum_max_eager_freeze_failure_rate |
vacuum_truncate
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Enables vacuum to truncate empty pages at the end of the table. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | vacuum_truncate |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_insert_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_scale_factor |
autovacuum_vacuum_insert_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 1000 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_insert_threshold |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 2 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |
autovacuum
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Controls whether the server should run the autovacuum subprocess. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | autovacuum |
autovacuum_analyze_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.1 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_scale_factor |
autovacuum_analyze_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_analyze_threshold |
autovacuum_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in transactions) before triggering autovacuum on a table to prevent transaction ID wraparound. |
| Data type | integer |
| Default value | 200000000 |
| Allowed values | 100000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_freeze_max_age |
autovacuum_max_workers
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets the maximum number of simultaneously running autovacuum worker processes. |
| Data type | integer |
| Default value | 3 |
| Allowed values | 1-262143 |
| Parameter type | static |
| Documentation | autovacuum_max_workers |
autovacuum_multixact_freeze_max_age
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Maximum age (in multixact) before triggering autovacuum on a table to prevent multixact wraparound. |
| Data type | integer |
| Default value | 400000000 |
| Allowed values | 10000-2000000000 |
| Parameter type | static |
| Documentation | autovacuum_multixact_freeze_max_age |
autovacuum_naptime
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets minimum delay between autovacuum runs on any given database. |
| Data type | integer |
| Default value | 60 |
| Allowed values | 1-2147483 |
| Parameter type | dynamic |
| Documentation | autovacuum_naptime |
autovacuum_vacuum_cost_delay
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | 20 |
| Allowed values | -1-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_delay |
autovacuum_vacuum_cost_limit
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Sets cost limit value that will be used in automatic VACUUM operations. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-10000 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_cost_limit |
autovacuum_vacuum_scale_factor
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. |
| Data type | numeric |
| Default value | 0.2 |
| Allowed values | 0-100 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_scale_factor |
autovacuum_vacuum_threshold
| Attribute | Value |
|---|---|
| Category | Autovacuum |
| Description | Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | autovacuum_vacuum_threshold |