Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F12179FB58C for ; Tue, 27 Mar 2007 10:06:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 56607-07 for ; Tue, 27 Mar 2007 10:06:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id D57D79FB560 for ; Tue, 27 Mar 2007 10:06:41 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so1745535ugf for ; Tue, 27 Mar 2007 06:06:39 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AMJTzaglFxAmQE8isup/1/dXwuf4ILpSi0TLTbpPk06vsOOA93UZhHQYqNzAlY4UJu/96i2X46y3PUS+MaQ02Tq09P0DOOGjZII/37zlwZZCO0Jt5812Eiyh1sMOxYElHxfi7ZDDk31OcqWvlv9bbNQhVsmVzrErG92D1MSCxfQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ty1vqXapuxycvsR5jGGw1yt2TcvvLkOt3dNPE80nXGRqHd51P4N3XjOifzXEDOK2fX1r1CY+NaSCpRo/6evkIqxxmZYgIO4q10A636FE3HDm2lt80x6k+pn2A0O6DofRkgwow0TbOA478/mPWowM+LRAxCJrhSR19HxmLHiuuwQ= Received: by 10.78.171.20 with SMTP id t20mr3524986hue.1175000798955; Tue, 27 Mar 2007 06:06:38 -0700 (PDT) Received: by 10.78.35.18 with HTTP; Tue, 27 Mar 2007 06:06:38 -0700 (PDT) Message-ID: Date: Tue, 27 Mar 2007 09:06:38 -0400 From: "Merlin Moncure" To: "Tom Lane" Subject: Re: [GENERAL] ERROR: out of shared memory Cc: "Sorin N. Ciolofan" , pgsql-general@postgresql.org, pgsql-admin@postgresql.org, pgsql-performance@postgresql.org In-Reply-To: <11069.1174966638@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070326123127.55F808E40FC@mailhost.ics.forth.gr> <11069.1174966638@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/210 X-Sequence-Number: 25034 On 3/26/07, Tom Lane wrote: > "Sorin N. Ciolofan" writes: > > I have to manage an application written in java which call another module > > written in java which uses Postgre DBMS in a Linux environment. I'm new to > > Postgres. The problem is that for large amounts of data the application > > throws an: > > org.postgresql.util.PSQLException: ERROR: out of shared memory > > AFAIK the only very likely way to cause that is to touch enough > different tables in one transaction that you run out of lock entries. > While you could postpone the problem by increasing the > max_locks_per_transaction setting, I suspect there may be some basic > application misdesign involved here. How many tables have you got? or advisory locks...these are easy to spot. query pg_locks and look for entries of locktype 'advisory'. I've already seen some apps in the wild that use them, openads is one. merlin