pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNumber of connections still limited on Windows 64-bit?
5+ messages / 3 participants
[nested] [flat]
* Number of connections still limited on Windows 64-bit?
@ 2011-12-07 12:46 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2011-12-08 12:04 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
0 siblings, 1 reply; 5+ messages in thread
From: Jan-Peter Seifert @ 2011-12-07 12:46 UTC (permalink / raw)
To: pgsql-admin
Hello,
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...
Thank you very much for any new information on this matter.
Peter
--
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
Jetzt informieren: http://www.gmx.net/de/go/freephone
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Number of connections still limited on Windows 64-bit?
2011-12-07 12:46 Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
@ 2011-12-08 12:04 ` lst_hoe02@kwsoft.de
2011-12-13 16:15 ` Re: Number of connections still limited on Windows 64-bit? Jan-Peter.Seifert@gmx.de
0 siblings, 1 reply; 5+ messages in thread
From: lst_hoe02@kwsoft.de @ 2011-12-08 12:04 UTC (permalink / raw)
To: pgsql-admin
Zitat von Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>:
> Hello,
>
> 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...
>
> Thank you very much for any new information on this matter.
http://support.microsoft.com/kb/947246/en-us
Regards
Andreas
Attachments:
smime.p7s (application/pkcs7-signature, 6.0K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Number of connections still limited on Windows 64-bit?
2011-12-07 12:46 Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2011-12-08 12:04 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
@ 2011-12-13 16:15 ` Jan-Peter.Seifert@gmx.de
2011-12-15 17:40 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
0 siblings, 1 reply; 5+ messages in thread
From: Jan-Peter.Seifert@gmx.de @ 2011-12-13 16:15 UTC (permalink / raw)
To: lst_hoe02@kwsoft.de; pgsql-admin
Hello Andreas,
thank you very much for the link.
-------- 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.
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.
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?).
Thank you very much,
Peter
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Number of connections still limited on Windows 64-bit?
2011-12-07 12:46 Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2011-12-08 12:04 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
2011-12-13 16:15 ` Re: Number of connections still limited on Windows 64-bit? Jan-Peter.Seifert@gmx.de
@ 2011-12-15 17:40 ` lst_hoe02@kwsoft.de
2011-12-18 18:41 ` Re: Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
0 siblings, 1 reply; 5+ messages in thread
From: lst_hoe02@kwsoft.de @ 2011-12-15 17:40 UTC (permalink / raw)
To: pgsql-admin
Zitat von Jan-Peter.Seifert@gmx.de:
> Hello Andreas,
>
> thank you very much for the link.
>
> -------- 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.
> 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...
Regards
Andreas
Attachments:
smime.p7s (application/pkcs7-signature, 6.0K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Number of connections still limited on Windows 64-bit?
2011-12-07 12:46 Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2011-12-08 12:04 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
2011-12-13 16:15 ` Re: Number of connections still limited on Windows 64-bit? Jan-Peter.Seifert@gmx.de
2011-12-15 17:40 ` Re: Number of connections still limited on Windows 64-bit? lst_hoe02@kwsoft.de
@ 2011-12-18 18:41 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
0 siblings, 0 replies; 5+ messages in thread
From: Jan-Peter Seifert @ 2011-12-18 18:41 UTC (permalink / raw)
To: lst_hoe02@kwsoft.de; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-12-18 18:41 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-07 12:46 Number of connections still limited on Windows 64-bit? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2011-12-08 12:04 ` lst_hoe02@kwsoft.de
2011-12-13 16:15 ` Jan-Peter.Seifert@gmx.de
2011-12-15 17:40 ` lst_hoe02@kwsoft.de
2011-12-18 18:41 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
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