有什么方法可以增加max_locks_per_transaction？ [英] Any way to increase max_locks_per_transaction?

问题描述

我们正在尝试在Azure SQL中为PGS托管PGS解决方案。使用max_locks_per_transaction的预配置限制遇到直接问题。看来这个服务器参数不可修改。是否可以通过支持电话增加？

We're trying to host a PGS solution in Azure SQL for PGS. Running into immediate issues with the pre-configured limit for max_locks_per_transaction. It seems this server parameter is not modifiable. Can it be increased with a support call?

推荐答案

嗨Leonardo，

Hi Leonardo,

您可能会找到../data/postgresql.conf文件，然后使用记事本编辑，如果它看起来像＃max_locks_per_transaction，则设置max_locks_per_transaction = 1024 ...您必须删除＃。
它必须如下：max_locks_per_transaction = 1024＃min 10，而不是保存并重新启动postgresql。

You might find ../data/postgresql.conf file, then edit with notepad, set max_locks_per_transaction = 1024 if it looks like # max_locks_per_transaction... you must remove #. It must look like that: max_locks_per_transaction = 1024 # min 10, than save it and restart postgresql.

Ref StackOverFLow link：  StackOverFlow帖子

Ref StackOverFLow link : StackOverFlow thread

希望它会有所帮助。

这篇关于有什么方法可以增加max_locks_per_transaction？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！