Re: [CYGWIN] resource leak in 7.2

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Pfau" <T(dot)Pfau(at)emCrit(dot)com>, "Jason Tishler" <jason(at)tishler(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>, <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: [CYGWIN] resource leak in 7.2
Date: 2002-02-08 18:14:41
Message-ID: EKEJJICOHDIEMGPNIFIJMELKGLAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-cygwin

> -----Original Message-----
> From: Tom Pfau
>
> I'm attaching two sql scripts in a zip file. Run script1.sql from one
> session. After it's done with the inserts, start script2.sql in another
> session. Have task manager running in the background and watch the
> backends eat handles.

I tested the srcipt with both cygipc-1.09 and my patched cygipc-1.09
(Where have my postings on Feb 6 gone ?).

With about 20 concurrent clients running
1) cygipc-1.09
Handles 9000 ---> 23000 or so.
2) my patched
Handles 9000 ---> 15600 or so.

So at least one of the cause seems the semaphore handle leak
in the cygipc library.

regards,
Hiroshi Inoue

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-02-08 19:03:42 Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0
Previous Message Tom Lane 2002-02-08 16:09:50 Re: Bug #577: incorect sort using order by

Browse pgsql-cygwin by date

  From Date Subject
Next Message Padma Sundar Narayanan 2002-02-08 22:11:46 Screen Overflow problem
Previous Message Jason Tishler 2002-02-08 11:59:59 Re: [BUGS] resource leak in 7.2