pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alfonso Moscato <alfonso.moscato@merqurio.it>
To: 'Rui DeSousa' <rui@crazybean.net>
Cc: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: R: repeated out of shared memory error - not related to max_locks_per_transaction
Date: Fri, 20 Jul 2018 16:46:28 +0200
Message-ID: <018201d42038$7146a6a0$53d3f3e0$@merqurio.it> (raw)
In-Reply-To: <E94C6526-93DF-44CC-BCF6-11AC1CAEAAD0@crazybean.net>
References: <00a601d4201a$e2291a10$a67b4e30$@merqurio.it>
	<17662.1532096551@sss.pgh.pa.us>
	<016801d42037$4f5d4630$ee17d290$@merqurio.it>
	<E94C6526-93DF-44CC-BCF6-11AC1CAEAAD0@crazybean.net>

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 importantly what’s the Commit Limit?







view thread (16+ messages)  latest in thread

Message-ID: <018201d42038$7146a6a0$53d3f3e0$@merqurio.it>
Permalink:  ../018201d42038$7146a6a0$53d3f3e0$@merqurio.it/
Also on:    postgresql.org/message-id/018201d42038$7146a6a0$53d3f3e0$@merqurio.it

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alfonso.moscato@merqurio.it, rui@crazybean.net, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
  Subject: Re: R: repeated out of shared memory error - not related to max_locks_per_transaction
  In-Reply-To: <018201d42038$7146a6a0$53d3f3e0$@merqurio.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox