Re: 8.2.3: Server crashes on Windows using Eclipse/Junit - Mailing list pgsql-hackers

From Trevor Talbot
Subject Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Date
Msg-id 90bce5730711101517n5d3a1cc7o74dba93daa92ec7f@mail.gmail.com
Whole thread Raw
In response to Re: 8.2.3: Server crashes on Windows using Eclipse/Junit  ("Trevor Talbot" <quension@gmail.com>)
Responses Re: 8.2.3: Server crashes on Windows using Eclipse/Junit  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On 10/26/07, I wrote:
> On 10/26/07, Magnus Hagander <magnus@hagander.net> wrote:
>
> > Can you try the attached patch? See how many backends you can get up to.
> >
> > This patch changes from using a single thread for each backend started to
> > using the builtin threadpool functionality. It also replaces the pid/handle
> > arrays with an i/o completion port. The net result is also, imho, much more
> > readable code :-)
>
> The patch looks good; I'm not set up to build yet, but I should be
> able to test it sometime in the next week.

Sorry about the long delay; I retested with the 8.3-beta2 installer,
still Win2003 SP2 32bit.

I stopped the test at 824 connections because I was about to run out
of memory (1.25GB RAM + 3.75GB swap), but postmaster VM space usage
was only 191MB.

As for desktop heap, only 65KB of the service heap was allocated, or
about 80 bytes per connection.  No danger of hitting limits in the
kernel memory pools either.

Available RAM seems like a pretty reasonable limit to me ;)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] functions are returns columns
Next
From: "Trevor Talbot"
Date:
Subject: Win32 shared memory speed