Colin,
On Mon, Feb 24, 2003 at 03:54:14PM +0200, Colin Mangiagalli wrote:
> Is there a limit under postgresql/cygwin/windows to the maximum number
> of connections you can make to the database.
Yes, Cygwin has a limit of ~63 children per process (due to Cygwin's
fork() implementation). Hence, Cygwin PostgreSQL will have a similar
limit to the maximum number of database connections.
> I had this weird problem that there were about 35 connections open
> (looking at the windows task manager), all doing something (what I
> don't know) and the CPU usage was sitting at 100%
Time to debug. Attach via gdb or strace to determine what the spinners
are doing.
> What does that mean if the connections don't want to close normally?
Switch to Linux? :,)
> Is there a way to see what could have opened the connections?
Try the following:
http://www.sysinternals.com/ntw2k/source/tcpview.shtml
or one of the other great tools from Sysinternals.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6