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 ;)
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 |
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 |