Re: Shared Memory: out of memory

200000 tables is rather a lot.  As I'm sure someone on hackers will tell
you, postgres is not designed to handle such bad database design.

Alexaki Sofia wrote:
> 
> 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

-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com