The handles persist through restarting the postgresql service and restarting the IIS server. The handles are accumulating on the System process. I think the handles are created when the web service is accessed but that would mean the IIS worker processes would have responsibility and they don't seem to. Recycling the worker processes in IIS does nothing. And the worker processes have their own process w3wp.exe which never accumulate handles. It's probably not a postgresql thing or other people would be seeing it.
Adam Bruss Senior Development Engineer AWR Corporation 11520 N. Port Washington Rd., Suite 201 Mequon, WI 53092 USA P: 1.262.240.0291 x104 F: 1.262.240.0294 E: abr...@awrcorp.com W: http://www.awrcorp.com -----Original Message----- From: Marti Raudsepp [mailto:ma...@juffo.org] Sent: Tuesday, February 28, 2012 8:23 AM To: Adam Bruss Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] accumulating handles problem on machine running postgresql On Tue, Feb 28, 2012 at 04:34, Adam Bruss <abr...@awrcorp.com> wrote: > The problem is the > Handle count on the Windows System process of the server, image name > c:\windows\system32\ntoskrnl.exe, accumulates over time and the handles > never get released. This causes the handle count to go to about 130,000 at > which time the machine starts malfunctioning and a reboot is needed. Do these handles go away when you restart any of these services? If it's a user space code problem then the handles should get freed automatically after the process exits. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
