| 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: | Whole Thread | Raw Message | 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-
| 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 |