From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sorin N. Ciolofan <ciolofan@ics.forth.gr>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [GENERAL] ERROR: out of shared memory
Date: Mon, 26 Mar 2007 23:37:18 -0400
Message-ID: <11069.1174966638@sss.pgh.pa.us> (raw)
In-Reply-To: <20070326123127.55F808E40FC@mailhost.ics.forth.gr>
References: <20070326123127.55F808E40FC@mailhost.ics.forth.gr>
"Sorin N. Ciolofan" <ciolofan@ics.forth.gr> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, ciolofan@ics.forth.gr, pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: [GENERAL] ERROR: out of shared memory
In-Reply-To: <11069.1174966638@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox