We already pre-allocate all shared memory and resources on postmaster start.
I guess we allocate memory when a backend starts, don't we? Or do we allocate when the instance starts?
I have two explanations for the following behaviour:
a. a bug b. not enough shared memory
WARNING: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost
The problem is that this only happens with mod_perl and Apache on the same machine so I thought it has to do with a known memory leak in mod_perl/Apache. I happens after about two weeks (it seems to occur regularily).
Are you suggesting pre-acquiring resources like oracle does? Like you start a database instance, 350MB memory is gone types?
One thing I love about postgresql is that it does not do any such silly thing. I agree in the case you suggest, it makes sense.
If at all postgresql goes that way, I would like to see it configurable. I would rather remove an app. from a machine rather than letting it stamp on other apps feet.
Shridhar. Yes, when preallocating some memory it has to be configurable (default = off).
-- Cybertec Geschwinde u Schoenig Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria Tel: +43/2952/30706; +43/664/233 90 75 www.cybertec.at, www.postgresql.at, kernel.cybertec.at
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly