Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: listas(at)lozano(dot)eti(dot)br, Rick Gigger <rick(at)alpinenetworking(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Randolf Richardson <rr(at)8x(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL
Date: 2004-01-31 00:51:17
Message-ID: 20040131005117.GA31663@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 30, 2004 at 03:45:08PM -0500, Doug McNaught wrote:
> listas(at)lozano(dot)eti(dot)br writes:
>
> > I can't imagine how a web server cannot be affected by apps creating
> > threads and/or proccesses. Think about memmory use, resource
> > pooling, syncronization issues, ... remember a child process ot
> > thread prevents the termination of its parent (which may become a
> > zombie on Unix systems, and a zombie still holds its open file
> > handles).
>
> This is wrong. Parents *can* terminate with running children, and
> zombie processes take up no resources other than a process table slot.

Additional zombie processes are automatically cleared when their parent dies
(they are reparented to init, which then takes care of it).

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ljb 2004-01-31 00:58:53 Re: Problem with API (libpq) - detailed error codes
Previous Message Gregory S. Williamson 2004-01-31 00:50:40 Re: IDENT and pg_hda.conf