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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for