Lock Management
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
deadlock_timeout
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock. |
Data type | integer |
Default value | 1000 |
Allowed values | 1-2147483647 |
Parameter type | dynamic |
Documentation | deadlock_timeout |
max_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of locks can be taken per transaction. When running a replica server, you must set this parameter to the same or higher value than on the master server. |
Data type | integer |
Default value | 64 |
Allowed values | 10-8388608 |
Parameter type | static |
Documentation | max_locks_per_transaction |
max_pred_locks_per_page
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked tuples per page. |
Data type | integer |
Default value | 2 |
Allowed values | 0-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_page |
max_pred_locks_per_relation
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate-locked pages and tuples per relation. |
Data type | integer |
Default value | -2 |
Allowed values | -2147483648-2147483647 |
Parameter type | dynamic |
Documentation | max_pred_locks_per_relation |
max_pred_locks_per_transaction
Attribute | Value |
---|---|
Category | Lock Management |
Description | Sets the maximum number of predicate locks per transaction. |
Data type | integer |
Default value | 64 |
Allowed values | 64 |
Parameter type | read-only |
Documentation | max_pred_locks_per_transaction |
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें