On Tue, Aug 26, 2014 at 1:32 PM, Dhruv Shukla <dhruvshukla82@gmail.com> wrote: > Scott, > Thanks for such a valuable information. I will have a look into it and have > it debugged. > > But now things have started slowing down really. Some programs have started > to throw errors like > > ERROR: DB COPY failed: DBD::Pg::db pg_endcopy > failed: ERROR: out of shared memory > HINT: You might need to increase max_locks_per_transaction. > > > These were things which were working before with higher memory settings. And > some are just running slow, slow means literally slow even though they are > connected via netstat and all.
OK increasing max locks per transaction is pretty safe. What did you change shared_mem from and too? Setting it a bit higher isn't terribly dangerous, like work_mem x max_conns can be.