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

Re: [GENERAL] ERROR: out of shared memory

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Sorin N(dot) Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr>, 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 13:06:38
Message-ID: b42b73150703270606w6c6605fbt12e863c8c9ef6366@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-performance
On 3/26/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "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?

or advisory locks...these are easy to spot.  query pg_locks and look
for entries of locktype 'advisory'.  I've already seen some apps in
the wild that use them, openads is one.

merlin

In response to

pgsql-performance by date

Next:From: Sorin N. CiolofanDate: 2007-03-27 13:13:42
Subject: Re: [GENERAL] ERROR: out of shared memory
Previous:From: RagnarDate: 2007-03-27 11:47:13
Subject: Re: Nested Loop

pgsql-admin by date

Next:From: Sorin N. CiolofanDate: 2007-03-27 13:13:42
Subject: Re: [GENERAL] ERROR: out of shared memory
Previous:From: Laszlo NagyDate: 2007-03-27 10:36:30
Subject: Re: autovacuum question

pgsql-general by date

Next:From: Peter ChildsDate: 2007-03-27 13:10:38
Subject: Re: [OT] cutting out the middleperl
Previous:From: Merlin MoncureDate: 2007-03-27 12:51:50
Subject: Re: cutting out the middleperl

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