How to increase 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 #.

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

than save it and restart postgresql

Leave a Comment