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 | Adaptive Autovacuum |
| 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 server parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum server parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| 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 server parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum server parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| 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 server parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum server parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| 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 server parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum server parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| 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 server parameter tuning as disabled ('OFF') or enabled to tune and update autovacuum server parameters. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | adaptive_autovacuum.optimize_configurations |
adaptive_autovacuum.open_transaction_threshold
| Attribute | Value |
|---|---|
| Category | Adaptive Autovacuum |
| 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 doesn't have any parameter in the 'Adaptive Autovacuum' category.
Note
Azure Database for PostgreSQL flexible server 11 doesn't have any parameter in the 'Adaptive Autovacuum' category.