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

Shared Memory: out of memory

From: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Shared Memory: out of memory
Date: 2000-12-19 14:51:45
Message-ID: Pine.GSO.4.10.10012191644110.21249-100000@athena.ics.forth.gr (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello,

I'm working with the JDBC driver from the Postgresql 7.0.2 distribution.

My application creates transactions consisting of about 3000
updates operations ('insert into table'  and 'create table').
My database consists of a huge (200000) number of tables which 
form a hierarchy.

The postmaster throws the following error massage

>NOTICE:  ShmemAlloc: out of memory 
>FATAL 1:  LockAcquire: lock table 1 is corrupted

What can have caused this error? How can I overcome it? 
Should I define the parameter -B of the postmaster?

Thank you in advance
Sofia Alexaki



Responses

pgsql-interfaces by date

Next:From: Jimi ThompsonDate: 2000-12-19 15:16:31
Subject: Perl & Postgres
Previous:From: Clark, JoelDate: 2000-12-19 13:44:18
Subject: RE: Connection Pooling...(Repost)...please do help..

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