Do you know that if you run LND with PostgreSQL backend, you should increase `max_locks_per_transaction` and `max_pred_locks_per_transaction` postgres parameters? Otherwise, LND overwhelm postgres locks which leads to crash the db on "out of shared memory".

See the tuning guide [1] and deep discussion on github [2]

[1] https://gist.github.com/djkazic/526fa3e032aea9578997f88b45b91fb9

[2] https://github.com/lightningnetwork/lnd/discussions/9541