Postgres/Cygwin - Semaphores

From: Saravanan Bellan <Saravanan(dot)Bellan(at)veritas(dot)com>
To: "'pgsql-cygwin(at)postgresql(dot)org'" <pgsql-cygwin(at)postgresql(dot)org>
Subject: Postgres/Cygwin - Semaphores
Date: 2003-04-08 04:16:58
Message-ID: C3CC003A39C7D411910F0008C786A645055F07AC@mtvxch12.veritas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

We use Tomcat(4.1) DBCP Connection pooling to access Postgres(7.2.1) on
Windows.
What we notice is that the number of handles used by the postmaster process
on the server
gradually increases if the same connection is used for update operations for
a extended period of time.
In a couple of days of high activity the number of handles is in the range
of 2 million and
eventually crashes the server.

You can see the number of handles in Windows Task manager. With the Process
Explorer tool
(www.sysinternals.com) you could see that these handles are all Semaphore
handles.

Running Vacuum at regular intervals helps to prolong the crash by some more
days.

Any suggestions,

Thanks,

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2003-04-08 11:22:29 Re:
Previous Message Andrew Bailey 2003-04-07 22:29:22 What services should be running for PostgreSQL to run as a service?