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.
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
adaptive_autovacuum.optimize_configurations
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| Description | Configures parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | static |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
adaptive_autovacuum.optimize_configurations
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| Description | Configures parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | static |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
adaptive_autovacuum.optimize_configurations
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| Description | Configures parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | static |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
adaptive_autovacuum.optimize_configurations
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| Description | Configures parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | static |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
adaptive_autovacuum.optimize_configurations
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| Description | Configures parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | static |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Customized Options |
| Description | Specifies the timeout, in seconds, before an orphan transaction is rolled back and before a long running transaction is terminated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483 |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.open_transaction_threshold |
Note
Azure Database for PostgreSQL Flexible Server 12 does not have any parameter in the 'Adaptive Autovacuum' category.
Note
Azure Database for PostgreSQL Flexible Server 11 does not have any parameter in the 'Adaptive Autovacuum' category.