Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C8B869FB704 for ; Thu, 5 Apr 2007 21:25:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94312-02 for ; Thu, 5 Apr 2007 21:25:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 49B4E9FB6D2 for ; Thu, 5 Apr 2007 21:25:15 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id CACB83090A; Fri, 6 Apr 2007 02:25:12 +0200 (MET DST) From: Joseph S X-Newsgroups: pgsql.general Subject: Re: ERROR: out of shared memory Date: Thu, 05 Apr 2007 20:25:11 -0400 Organization: Hub.Org Networking Services Lines: 1 Message-ID: <46159367.5030508@selectacast.net> References: <19352.1175003955@sss.pgh.pa.us> <20070330131926.B9DC18E40FC@mailhost.ics.forth.gr> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: "Sorin N. Ciolofan" User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.10) Gecko/20070302 Fedora/1.5.0.10-1.fc6 pango-text Thunderbird/1.5.0.10 Mnenhy/0.7.4.0 In-Reply-To: <20070330131926.B9DC18E40FC@mailhost.ics.forth.gr> To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/283 X-Sequence-Number: 112186 Try doing select * from pg_locks to see how many locks you have out.