> -----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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html