Re: [SQL] zombie postmasters

From: Zalman Stern <zalman(at)netcom(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Cc: hamid(at)emarq(dot)com, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] zombie postmasters
Date: 1999-11-17 08:44:15
Message-ID: 199911170844.AAA25336@netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> "Hamid Khoshnevis" <hamid(at)emarq(dot)com> writes:
> > In a web environment, a user can repeatedly starts and abort large queries
> > which create a large number of zombie postmasters.

The first question is whether you mean real "zombies" (as indicated by ps)
or a bunch more process than you expected ("process leak"). I've seen the
latter a number of times and it generally indicates failure to properly
close connections in your application. I find the same techniques used for
debuging file descriptor leaks work for finding these problems.

-Z-

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message jose soares 1999-11-17 13:34:36 Re: [SQL] ODBC/Openlink/Delphi
Previous Message Jan Wieck 1999-11-17 08:26:52 Re: [SQL] zombie postmasters