如何增加max_locks_per_transaction [英] How to increase max_locks_per_transaction

问题描述

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

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

错误:共享内存不足

ERROR: out of shared memory

提示:您可能需要增加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 = 1024 if 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！