What is the root cause of 'out of shared memory ' issue?
0
votes
1
answer
542
views
I'm having 'out of shared memory' issue in PostgreSQL 13.3 on x86_64-pc-linux-gnu (The database has 41G data), first, it suggested me to increase max_locks_per_transaction.
After increasing max_locks_per_transaction to 1024, I still get 'out of shared memory', but now it suggests:
ERROR: out of shared memory
HINT: You might need to increase max_pred_locks_per_transaction.
It seems very confusing to me. So my question:
- Why does max_pred_locks_per_transaction affect on shared_memory ?
- The shared_buffers is already 4GB, should I increase it ?
- The 'out of shared memory' relates to which: max_locks_per_transaction * (max_connections + max_prepared_transactions) or shared_buffers ?
Thank you all.
Asked by MiH
(125 rep)
Mar 29, 2024, 12:19 PM
Last activity: Mar 30, 2024, 09:09 AM
Last activity: Mar 30, 2024, 09:09 AM