From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: Shared Memory: out of memory |
Date: | 2000-12-20 02:41:33 |
Message-ID: | 3A401C5D.AD66E52C@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-12-20 02:48:09 | Re: Re: [HACKERS] Trigger |
Previous Message | Clark, Joel | 2000-12-20 01:47:59 | RE: Connection Pooling...(Repost)...please do help.. |