Skip to content

Instantly share code, notes, and snippets.

@akaDPR
Created February 20, 2020 06:40
Show Gist options
  • Save akaDPR/275ebe30c3852598cc944d77a2b16f09 to your computer and use it in GitHub Desktop.
Save akaDPR/275ebe30c3852598cc944d77a2b16f09 to your computer and use it in GitHub Desktop.
Increase max_locks_per_transaction - postgres
1) port-forward your postgres instance to localhost
2) psql -U admin -h localhost -p 6432 -d <db-name>
In the above command , I port-forwaded the postgres micro-service to localhost port 6432
3) Once you enterd to psql terminal ,
4) <db-name>#= SHOW max_locks_per_transaction;
5) <db-name>#= ALTER SYSTEM SET max_locks_per_transaction = 1024;
6) Restart your postgres instance
7) now check the max_locks_per_transaction
thanks , altruist.curio@gmail.com
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment