本文介绍了如何增加max_locks_per_transaction的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我一直在通过PostgreSQL服务器进行密集的模式删除和创建,

I've been performing kind of intensive schema dropping and creating over a PostgreSQL server,

提示:您可能需要增加max_locks_per_transaction.

HINT: You might need to increase max_locks_per_transaction.

我需要增加max_locks_per_transaction,但如何在 MAC OSX

I need to increase max_locks_per_transaction but how can i increase it in MAC OSX

推荐答案

您可能会找到../data/postgresql.conf文件,然后使用记事本进行编辑,设置max_locks_per_transaction = 1024如果它看起来像#max_locks_per_transaction ...,则必须删除#.

you might find ../data/postgresql.conf file, then edit with notepad, set max_locks_per_transaction = 1024if it looks like # max_locks_per_transaction... you must remove #.

它必须看起来像这样:max_locks_per_transaction = 1024#分钟10

it must look like that:max_locks_per_transaction = 1024 # min 10

然后保存并重新启动postgresql

than save it and restart postgresql

这篇关于如何增加max_locks_per_transaction的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 09:17