From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Rainer Bauer <usenet(at)munnin(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
Date: | 2007-10-22 13:33:18 |
Message-ID: | 471CA69E.6080901@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Magnus Hagander wrote:
> Another followup. Been working with Dave on and off today (well, him mostly
> on to be honest, me a bit more on and off), and it seems that both our
> repros clearly blame the desktop heap, and nothing else. Please use the
> desktop heap tool and see if it breaks when the desktop heap usage
> approaches 100%:
>
> http://www.microsoft.com/downloads/details.aspx?familyid=5cfc9b74-97aa-4510-b4b9-b2dc98c8ed8b&displaylang=en
>
> It'd still be good to know why the difference is so big between your two
> systems.
Further info on this for the record - on XP Pro (which I'm testing on),
the desktop heap size defaults to 512KB for non-interactive sessions and
3072KB for interactive. In testing I find that I can get up to around 46
or so connections when running as a service before desktop heap is
exhausted and postgres dies.
When running interactively I can get a little over 125 connections
before things start dying, however, in that case it's *not* because of
dekstop heap, because I can start a second cluster and run 125
connections on each simultaneously.
If I run three instances up together, one of them will die as soon as
desktop heap gets to 100% usage.
So, we seem to be hitting two limits here - the desktop heap, and
something else which is cluster-specific. Investigation continues...
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Rainer Bauer | 2007-10-22 14:03:35 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
Previous Message | Magnus Hagander | 2007-10-22 12:41:42 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-10-22 13:38:24 | Re: pgadmin debug on windows |
Previous Message | Roberto Icardi | 2007-10-22 13:26:37 | pgadmin debug on windows |