Re: accumulating handles problem on machine running postgresql

From: dennis jenkins <dennis(dot)jenkins(dot)75(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: accumulating handles problem on machine running postgresql
Date: 2012-02-28 22:01:23
Message-ID: CAAEzAp-C2ygL0pERFjiExV0wt-Cp7+WiaJAMi+1_cpsChKy3Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 28, 2012 at 8:48 AM, Adam Bruss <abruss(at)awrcorp(dot)com> wrote:
> 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.
>

Use "process explorer" from sysinternals / microsoft (google for it)
to see what these handles are for (pipes, files, events, mutants,
desktops, winstations (ok, probably not those), etc...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lummis, Patrick J 2012-02-28 22:06:17 Re: Stored Procedure Record Updates using For Loops - Postgres 8.1
Previous Message Devrim GÜNDÜZ 2012-02-28 20:54:44 Re: Error installing postgresq91-python package