如何增加 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,

错误:共享内存不足

提示:您可能需要增加 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屋！