Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5B5CE9FB760 for ; Fri, 11 May 2007 15:42:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 27683-09 for ; Fri, 11 May 2007 15:42:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 57AD89FB3EA for ; Fri, 11 May 2007 15:42:43 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id a73so891428pye for ; Fri, 11 May 2007 11:42:42 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=HpZ9sCLBehC/orjQXcxATNJhETwlXzw+v+ampcgxm6hTNQSuOnJjOTTH8mm9mT0JU4Q/5Yee3PoZja8knVlSmjm4LZ2fYjqZ9xUfnsOmA5EdRfZ56cEDhBlOjbzLFpHtzqx6iPL8uDhgmoqhxUdFjSmqPNj6+X4RVfOLeQPIIQE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=JI4YIAwmmWI71pmEJakQr1FnLxIVrgheqiju5ARb0h2XnJ/5rroSl8h8fk0GQcBx+2o57zcsSpEvUOmXTEzvei35SkRs5hc0t0UmH3Qak/qc9UnJJDmsQEkATZ+IhVxblRQ3LlofFzppwiV52JIJ322PGdjHCEkfNvYhZgvKVB0= Received: by 10.35.106.1 with SMTP id i1mr5490548pym.1178908962393; Fri, 11 May 2007 11:42:42 -0700 (PDT) Received: from ?192.168.1.83? ( [206.114.45.106]) by mx.google.com with ESMTP id 12sm48357679nzn.2007.05.11.11.42.41; Fri, 11 May 2007 11:42:41 -0700 (PDT) Subject: Re: increasing of the shared memory does not solve the problem of "OUT of shared memory" From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-admin@postgresql.org In-Reply-To: <20070511135727.ECEDB8E40FC@mailhost.ics.forth.gr> References: <20070511135727.ECEDB8E40FC@mailhost.ics.forth.gr> Content-Type: text/plain Date: Fri, 11 May 2007 14:41:37 -0400 Message-Id: <1178908897.4331.63.camel@aleph.whitemice.org> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/96 X-Sequence-Number: 25416 > I increased significantly the number of shared buffers from 3000 to > 100 000 (80Mb) > Also I increased the max_locks_per_transaction from 64 to 10 000. > I still receive the same error form Postgres: > org.postgresql.util.PSQLException: ERROR: out of shared memory > Is this message appropriate to the real cause of the problem or the > reason of the failure is actually other than what is displayed in this > message? > Maybe you've got an application that is doing a BEGIN WORK, but never doing a rollback or commit? -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org