PostgreSQL “ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction”

在使用 PostgreSQL 数据库时,可能会看到过该错误消息,最近在highGoDB(postgresq)一个大的业务库做drop database时有遇到,也可能查询pgp_dump或查看表对象大小(如几千个分区)时,会提示提示错误” ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.

,