Skip to content

Instantly share code, notes, and snippets.

View aandrieiev1998's full-sized avatar
😄
Hello!

Andrii Andrieiev aandrieiev1998

😄
Hello!
View GitHub Profile
@akaDPR
akaDPR / max_locks_per_transaction.txt
Created February 20, 2020 06:40
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;