Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B4B849FBC7F; Tue, 27 Mar 2007 00:38:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 65405-01-9; Tue, 27 Mar 2007 00:38:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ABD819FB7B9; Tue, 27 Mar 2007 00:37:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l2R3bIxk011070; Mon, 26 Mar 2007 23:37:18 -0400 (EDT) To: "Sorin N. Ciolofan" cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [GENERAL] ERROR: out of shared memory In-reply-to: <20070326123127.55F808E40FC@mailhost.ics.forth.gr> References: <20070326123127.55F808E40FC@mailhost.ics.forth.gr> Comments: In-reply-to "Sorin N. Ciolofan" message dated "Mon, 26 Mar 2007 15:32:08 +0300" Date: Mon, 26 Mar 2007 23:37:18 -0400 Message-ID: <11069.1174966638@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/202 X-Sequence-Number: 25026 "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? regards, tom lane