12-05-2019, 01:10 PM
Hi Eric,
In the Postgres configuration file, usually found at /var/lib/pgsql/data/postgresql.conf, there is a line for max_locks_per_transaction.
You can change this line, and restart the Postgres service.
Well it's possible that you are in fact pushing the limits of data management, we rarely see this error while working with large amounts of data ourselves.
I am wondering what API methods you are using, and how you are using them. There might be a more efficient way to do the same task.
Best,
Celton
In the Postgres configuration file, usually found at /var/lib/pgsql/data/postgresql.conf, there is a line for max_locks_per_transaction.
You can change this line, and restart the Postgres service.
Well it's possible that you are in fact pushing the limits of data management, we rarely see this error while working with large amounts of data ourselves.
I am wondering what API methods you are using, and how you are using them. There might be a more efficient way to do the same task.
Best,
Celton