Florian Weimer <[EMAIL PROTECTED]> writes: > * Tom Lane: >> The $64 problem is that if the parent postmaster process is victimized >> by the OOM killer, you won't get an automatic restart.
> The classic answer to that is to put it into inittab. 8-/ Except that no standard services are actually run that way, for sundry good-n-sufficient reasons. >> In most people's eyes that is considerably worse than the momentary >> DOS imposed by a kill of a child backend. And what we now find, >> which is truly staggeringly stupid on the kernel's part, is that it >> *preferentially* kills the parent instead of whatever child might >> actually be eating the memory. > IIRC, the idea is to get the machine out of OOM land with one killed > process, even if it causes dependent processes to fail. You're just parroting the reasoning given on the cited webpage, which is loony because it takes no account whatsoever of actual practice. Postgres is hardly the only daemon for which killing the parent results in far worse DOS than not doing so. sendmail, sshd, inetd, and mysqld are examples that come to mind immediately, and I am fairly sure that it's true for apache as well. Also, how is killing parent and child less invasive than killing only the child (which is the one actually eating memory, in these cases)? The reasoning isn't even self-consistent. > No matter what you do at this point, you lose. Well, since the authors of the overcommit logic appear uninterested in running stable userland services, turning it off is the only way not to lose. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: 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