R: repeated out of shared memory error - not related to max_locks_per_transaction - Mailing list pgsql-admin

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@crazybean.net>
Inviato: venerdì 20 luglio 2018 16:45
A: Alfonso Moscato <alfonso.moscato@merqurio.it>
Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin@lists.postgresql.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
importantlywhat’s the Commit Limit?