Re: 8.2.3: Server crashes on Windows using Eclipse/Junit

From: "Trevor Talbot" <quension(at)gmail(dot)com>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "Dave Page" <dpage(at)postgresql(dot)org>
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Date: 2007-11-10 23:17:13
Message-ID: 90bce5730711101517n5d3a1cc7o74dba93daa92ec7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 10/26/07, I wrote:
> On 10/26/07, Magnus Hagander <magnus(at)hagander(dot)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 ;)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schröder 2007-11-11 01:45:30 Re: (Never?) Kill Postmaster?
Previous Message Julio Cesar Sánchez González 2007-11-10 22:20:23 Re: INSERT performance deteriorates quickly during a large import

Browse pgsql-hackers by date

  From Date Subject
Next Message Trevor Talbot 2007-11-10 23:31:59 Win32 shared memory speed
Previous Message Tom Lane 2007-11-10 23:14:50 Re: functions are returns columns