JM <jerome(at)gmanmi(dot)tv> writes:
> i need help on this.. i'm experiencing this problem too often and i need a
> permanent solution.
> WARNING: ShmemAlloc: out of memory
> ERROR: FreeSpaceMap hashtable out of memory
You probably need to increase max_locks_per_transaction some more.
It would also be a good idea to keep an eye on pg_locks and try to
figure out what's grabbing so many locks ...
regards, tom lane