Re: Limit on connections

From: Jason Tishler <jason(at)tishler(dot)net>
To: Colin Mangiagalli <colin(at)camara(dot)co(dot)za>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Limit on connections
Date: 2003-02-25 12:26:24
Message-ID: 20030225122624.GD1876@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

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

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2003-02-25 12:47:27 Re: problem with postgre install on windows
Previous Message Jason Tishler 2003-02-25 12:04:50 Re: What could be the cause?