Hi Rui. root@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@xxxxxxxxxxxxx> Inviato: venerdì 20 luglio 2018 16:45 A: Alfonso Moscato <alfonso.moscato@xxxxxxxxxxx> Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx 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?
