R: repeated out of shared memory error - not related to max_locks_per_transaction

Hi Rui.

root(at)pg:/etc/postgresql/9.6/main# cat /proc/meminfo
MemTotal: 92813728 kB
MemFree: 21016632 kB
MemAvailable: 80814496 kB
Buffers: 196328 kB
Cached: 67843352 kB
SwapCached: 0 kB
Active: 67040236 kB
Inactive: 3374184 kB
Active(anon): 7700380 kB
Inactive(anon): 2937896 kB
Active(file): 59339856 kB
Inactive(file): 436288 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 3905532 kB
SwapFree: 3905532 kB
Dirty: 496 kB
Writeback: 0 kB
AnonPages: 2374804 kB
Mapped: 6664260 kB
Shmem: 8263524 kB
Slab: 696048 kB
SReclaimable: 658492 kB
SUnreclaim: 37556 kB
KernelStack: 4464 kB
PageTables: 422148 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 50312396 kB
Committed_AS: 27622712 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 0 kB
VmallocChunk: 0 kB
HardwareCorrupted: 0 kB
AnonHugePages: 0 kB
CmaTotal: 0 kB
CmaFree: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 81856 kB
DirectMap2M: 94289920 kB

-----Messaggio originale-----
Da: Rui DeSousa <rui(at)crazybean(dot)net>
Inviato: venerdì 20 luglio 2018 16:45
A: Alfonso Moscato <alfonso(dot)moscato(at)merqurio(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; pgsql-admin(at)lists(dot)postgresql(dot)org
Oggetto: Re: repeated out of shared memory error - not related to max_locks_per_transaction

What is the systems memory settings (cat /proc/meminfo)? How much swap space is allocated to the system? And more importantly what’s the Commit Limit?