What can I do to monitor "out of shared memory" issues?
4
votes
1
answer
1223
views
I'm new to database administration and I would really like some advice on what tools I could use or what I could do to monitor "out of shared memory" issues.
I've been seeing these "out of shared memory" messages when I've been running *rspec* which runs tests for my application. I've also seen messages in the browser when I run my rails app that I "might need to increase max_locks_per_transaction."
I think it would be better to find out exactly what is going on first either on the driver level or the PostgreSQL level.
My specs are:
PostgreSQL 9.4.5 on x86_64-apple-darwin15.0.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit
I have a Macbook Pro running OSX El Capitan 10.11.5
I'm using the gem *pg* version 0.18.4 in my Ruby-on-Rails application.
Asked by alexia
(51 rep)
Jun 30, 2016, 04:28 AM
Last activity: May 1, 2021, 08:06 AM
Last activity: May 1, 2021, 08:06 AM