JM <jerome@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
