Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 77CB19FB798;
	Tue, 27 Mar 2007 10:59:54 -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 94112-01-2; Tue, 27 Mar 2007 10:59:40 -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 B292F9FB7B8;
	Tue, 27 Mar 2007 10:59:45 -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 l2RDxFNm019353;
	Tue, 27 Mar 2007 09:59:15 -0400 (EDT)
To: "Sorin N. Ciolofan" <ciolofan@ics.forth.gr>
cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org,
	pgsql-performance@postgresql.org
Subject: Re: [GENERAL] ERROR: out of shared memory 
In-reply-to: <20070327131301.065E38E40FC@mailhost.ics.forth.gr> 
References: <20070327131301.065E38E40FC@mailhost.ics.forth.gr>
Comments: In-reply-to "Sorin N. Ciolofan" <ciolofan@ics.forth.gr>
	message dated "Tue, 27 Mar 2007 16:13:42 +0300"
Date: Tue, 27 Mar 2007 09:59:15 -0400
Message-ID: <19352.1175003955@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/211
X-Sequence-Number: 25035

"Sorin N. Ciolofan" <ciolofan@ics.forth.gr> writes:
> It seems that the legacy application creates tables dynamically and the
> number of the created tables depends on the size of the input of the
> application. For the specific input which generated that error I've
> estimated a number of created tables of about 4000. 
> Could be this the problem?

If you have transactions that touch many of them within one transaction,
then yup, you could be out of locktable space.  Try increasing
max_locks_per_transaction.

			regards, tom lane