From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: desktop heap usage in windows |
Date: | 2010-04-06 07:05:08 |
Message-ID: | o2q9837222c1004060005vc3c45f03la2e539907fcc3766@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Apr 5, 2010 at 23:45, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> Magnus Hagander wrote:
>>
>> No, there's a problem with the Desktop Heap getting exhausted because
>> of system DLLs that allocate from it whenever they are loaded into a
>> process. It's in the Windows FAQ on wiki.postgresql.org - IIRC it's
>> right at the bottom.
>>
>> And yes, we still have the problem - it's a Windows problem, really,
>> not a PostgreSQL problem. It simply can't deal with many processes the
>> way the system DLLs are built. The exact limit varies between
>> installations - likely due to third party DLLs being loaded, like AV
>> and FW software.
>>
>> It may be that this is actually not a problem with the 64-bit version
>> of 9.0. I haven't tried that - probably should.
>>
>
> k, so the FAQ entry here [1] references the MSKB article [2] which, under
> Cause 2, talks about the SharedSection in the registry key [3]
>
> Presumably, tis the 3rd value, the 512, thats used by non-interactive
> sessions, thats the one that needs boosting?
>
> fwiw, on my win7 pro 64bit desktop, that reads...
>
> %SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
> SharedSection=1024,20480,768
> Windows=On SubSystemType=Windows ServerDll=basesrv,1
> ServerDll=winsrv:UserServerDllInitialization,3
> ServerDll=winsrv:ConServerDllInitialization,2 ServerDll=sxssrv,4
> ProfileControl=Off
> MaxRequestThreads=16
>
> which is larger (768) than the value shown in the KB article [2] (512)
Hmm. I was hoping for orders-of-magniture larger though, that would
remove the problem completely. This seems to just push it off a little
bit more (assuming it makes a difference, that should probably be
tested and not just assumed)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-04-06 07:42:07 | Re: desktop heap usage in windows |
Previous Message | Nikhil G. Daddikar | 2010-04-06 04:43:53 | Re: "1-Click" installer problems |