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