I don't know whether this really is a bug or is just
something I don't know how to configure in the db.
I wrote a PL/SQL stored procedure which performs a
huge transaction cca. 2 milion record insert.
The procedure performs transacting and atfer a while
error is thrwn: out od shared memory.
Up to this point everything is OK, even error is OK since I
have very modest shared memory segment configured in .ini
But here comes something I think it is a bug. Shared memory can not
be recovered from this point on. Everthing operation I try to
perform on db says: out of shared memory. And the only option
I have is to shutdown postmaster and start it again.
We are testing postreSQL to run it in production, but this is
unfortunately untolerable for us.
This strange behaviour is with version 8.0.0 beta1
With regards, Rikardo
P.S.: If this is not a bug, please tell me how to correct it.
pgsql-bugs by date
|Next:||From: Estevan Rech||Date: 2004-09-11 15:05:55|
|Subject: help in installation|
|Previous:||From: Bruce Momjian||Date: 2004-09-11 14:39:49|
|Subject: Re: 8.0 beta service won't start|