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 1fgWeN-0002MN-0z for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jul 2018 14:44:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgWeL-0003tq-An for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jul 2018 14:44:53 +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 1fgWeL-0003tj-3R for pgsql-admin@lists.postgresql.org; Fri, 20 Jul 2018 14:44:53 +0000 Received: from mtaout006-public.msg.strl.va.charter.net ([68.114.190.31]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgWeI-0007Zc-6L for pgsql-admin@lists.postgresql.org; Fri, 20 Jul 2018 14:44:52 +0000 Received: from impout001 ([68.114.189.16]) by mtaout006.msg.strl.va.charter.net (InterMail vM.9.00.023.01 201-2473-194) with ESMTP id <20180720144447.ZYUN7358.mtaout006.msg.strl.va.charter.net@impout001>; Fri, 20 Jul 2018 09:44:47 -0500 Received: from cerberus.crazybean.net ([24.151.10.150]) by impout001 with charter.net id D2kn1y0093EE3TL012knvM; Fri, 20 Jul 2018 09:44:47 -0500 X-Authority-Analysis: v=2.2 cv=ffHd8wYF c=1 sm=1 tr=0 a=D2HTw/M6/8MmcHighGO7rg==:117 a=D2HTw/M6/8MmcHighGO7rg==:17 a=IkcTkHD0fZMA:10 a=R9QF1RCXAYgA:10 a=JM8d_LCoA_CkhUEAAg8A:9 a=QEXdDO2ut3YA:10 Received: from [10.25.227.111] (144.121.139.193.lightower.net [144.121.139.193]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 5af7bddb (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Fri, 20 Jul 2018 10:44:46 -0400 (EDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 12.0 \(3445.100.17\)) Subject: Re: repeated out of shared memory error - not related to max_locks_per_transaction From: Rui DeSousa In-Reply-To: <016801d42037$4f5d4630$ee17d290$@merqurio.it> Date: Fri, 20 Jul 2018 10:44:45 -0400 Cc: Tom Lane , pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <00a601d4201a$e2291a10$a67b4e30$@merqurio.it> <17662.1532096551@sss.pgh.pa.us> <016801d42037$4f5d4630$ee17d290$@merqurio.it> To: Alfonso Moscato X-Mailer: Apple Mail (2.3445.100.17) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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?