From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: lst_hoe02@kwsoft.de
Cc: pgsql-admin@postgresql.org
Subject: Re: Number of connections still limited on Windows 64-bit?
Date: Sun, 18 Dec 2011 19:41:51 +0100
Message-ID: <4EEE33EF.3050603@gmx.de> (raw)
In-Reply-To: <20111215184017.18565s5emc5jxxwc@webmail.kwsoft.de>
References: <20111207124635.45500@gmx.net>
<20111208130430.14653bnpyytz6l6o@webmail.kwsoft.de>
<20111213161550.219250@gmx.net>
<20111215184017.18565s5emc5jxxwc@webmail.kwsoft.de>
Hello Andreas,
Am 15.12.2011 18:40, schrieb lst_hoe02@kwsoft.de:
> Zitat von Jan-Peter.Seifert@gmx.de:
>> -------- Original-Nachricht --------
>>> Datum: Thu, 08 Dec 2011 13:04:30 +0100
>>> Von: lst_hoe02@kwsoft.de
>>> Zitat von Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>:
>>
>>> > I wonder whether the number of connections is still limited on
>>> > Windows 64-bit if you also use a 64-bit version of PostgreSQL:
>>
>>> http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_wit...
>>>
>>
>>> http://support.microsoft.com/kb/947246/en-us
>>
>> So the default setting for Windows 7 64-Bit seems to be:
>> SharedSection=1024,20480,768
>>
>> Makes me wonder whether PostgreSQL ( as a service ) still uses the
>> 'Non-interactive desktop heap' for connections then.
>
> As far as i understand not PostgreSQL is using the heap but the system
> component user32.dll does. Not sure why user32.dll is needed but i
> remember Oracle at least back in 9.x days had the very same problem.
>
>> I used pgbench for testing 500 connections ( max_connections set to
>> 600 ):
>> Initialize:
>> pgbench -i -U postgres -h host -p port
>> Test:
>> pgbench -U postgres -h host -p port -c 500
>> Verify:
>> SELECT COUNT(*) FROM pg_stat_activity;
>>
>> The non-interactive Desktop Heap has been increased by just a half -
>> yet the number of connections can obviously be much higher than 200. I
>> guess the connections don't need less memory now though.
>
> I think i have read somewhere that MS has optimized the Desktop Heap
> usage in Vista and later, but not sure where it was.
I guess you mean this blog post:
http://blogs.msdn.com/b/ntdebugging/archive/2008/03/20/the-default-interactive-desktop-heap-size-has...
This seems to be an interesting post, too:
http://thundaxsoftware.blogspot.com/2011/10/monitoring-desktop-heap-memory-and_17.html>> Do the services share the same desktop (heap) or does each
>> (PostgreSQL) service has its own ( if I register each service for a
>> different Windows user?).
>
> To be honest i don't know at all...
I'll have a look then.
Thank you very much for your comments,
Peter
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de, lst_hoe02@kwsoft.de
Subject: Re: Number of connections still limited on Windows 64-bit?
In-Reply-To: <4EEE33EF.3050603@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox