I’m using liquibase with Postgres and I’m hitting the error when running a particular changeSet:
ERROR: out of shared memory
[ERROR] Hint: You might need to increase max_locks_per_transaction.
So I increased my max locks in Postgres to 512 and my changeSet was able to complete. However, I don’t want to do this on my production servers. Is there documentation on how to decrease the number of locks needed to complete a changeSet?
My changeSet needs to create 2000 schemas and 10 tables per schema.