Re: Limit on connections

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