Re: [SQL] zombie postmasters - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] zombie postmasters
Date
Msg-id 24411.942815127@sss.pgh.pa.us
Whole thread Raw
In response to zombie postmasters  ("Hamid Khoshnevis" <hamid@emarq.com>)
Responses Re: [SQL] zombie postmasters  (wieck@debis.com (Jan Wieck))
Re: [SQL] zombie postmasters  (Zalman Stern <zalman@netcom.com>)
List pgsql-sql
"Hamid Khoshnevis" <hamid@emarq.com> writes:
> In a web environment, a user can repeatedly starts and abort large queries
> which create a large number of zombie postmasters.

It shouldn't be possible for there to be zombie postgres processes ---
the postmaster process should reap dead backends more or less instantly.
Either your postmaster is getting wedged somehow, or there is a
configure/install problem that has broken the postmaster's handling
of child-process exit.  What platform are you using, exactly?  What
if anything shows up in the postmaster log when this happens?
        regards, tom lane


pgsql-sql by date:

Previous
From: maxsbox
Date:
Subject: ODBC/Openlink/Delphi
Next
From: "Gary MacMinn"
Date:
Subject: Re: [SQL] nulls and datetime