Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] ERROR: out of shared memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sorin N(dot) Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [GENERAL] ERROR: out of shared memory
Date: 2007-03-27 03:37:18
Message-ID: 11069.1174966638@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-performance
"Sorin N. Ciolofan" <ciolofan(at)ics(dot)forth(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Gauri KanekarDate: 2007-03-27 10:43:31
Subject: Re: Nested Loop
Previous:From: RagnarDate: 2007-03-26 16:22:33
Subject: Re: Nested Loop

pgsql-admin by date

Next:From: Tom LaneDate: 2007-03-27 03:58:23
Subject: Re: data from system tables.
Previous:From: Jim NasbyDate: 2007-03-26 22:10:05
Subject: Re: autovacuum question

pgsql-general by date

Next:From: Michael FuhrDate: 2007-03-27 04:10:09
Subject: Re: How can I select a comment on a column?
Previous:From: Tom LaneDate: 2007-03-27 03:33:45
Subject: Re: Every user has own database - how?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group