Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgWfx-0002UA-FV for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jul 2018 14:46:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgWfv-00067p-KV for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jul 2018 14:46:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgWfv-00067h-AS for pgsql-admin@lists.postgresql.org; Fri, 20 Jul 2018 14:46:31 +0000 Received: from smtp200-pc.aruba.it ([62.149.157.200] helo=smtpg-pc.aruba.it) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgWfs-0007Yx-DH for pgsql-admin@lists.postgresql.org; Fri, 20 Jul 2018 14:46:30 +0000 Received: from DT02 ([93.63.211.242]) by smtpcm2-pc.aruba.it with bizsmtp id D2mT1y00V5ELnP9012mUY6; Fri, 20 Jul 2018 16:46:28 +0200 From: "Alfonso Moscato" To: "'Rui DeSousa'" Cc: "'Tom Lane'" , References: <00a601d4201a$e2291a10$a67b4e30$@merqurio.it> <17662.1532096551@sss.pgh.pa.us> <016801d42037$4f5d4630$ee17d290$@merqurio.it> In-Reply-To: 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> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQJyTRksqbTjmmAqDGBi/OX9BtlRvgJEoSREAmxYurQCmWi3hqMhg4dA Content-Language: it DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aruba.it; s=a1; t=1532097988; bh=9aivEc0u0s7MwcT4+y9Kyki4Rcj0KIVbufYrIu2yDY4=; h=From:To:Subject:Date:MIME-Version:Content-Type; b=SiFGT7cAa+NylDEEXI8oyEBk0kWIw/Q1UI7kl8E1yug0VXWag3ZT8MkorH8nx/j4b 5iMY/oSDa1Nd5vZGpZ2C57NeLQIo5UPCbXNGtMRWcWHSGHZl0Jq3vm0cLXmipsaYOA lAHo27TNsr5wT6DBu9TfQyfZskzPL53xt0m4ACXORVL/R6qLX1qC6rTWrbC/d2Ah3f S5r5mSAJbtivZRcVtutmhh6KHAwYBcOD2KdqLYoh0cE5asRIZKoOYfyNI5fhIUzyu3 PhVkebkFAUtJoy4J4cq+JQwlRRIh0sK7jzksnL8/XfCHOio3BtxKb2GczD0SmWmoqN msc/u1W/XqRnQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 =20 Inviato: venerd=C3=AC 20 luglio 2018 16:45 A: Alfonso Moscato Cc: Tom Lane ; 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=E2=80=99s = the Commit Limit?