Skip site navigation (1) Skip section navigation (2)

Re: Number of connections still limited on Windows 64-bit?

From: lst_hoe02(at)kwsoft(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Number of connections still limited on Windows 64-bit?
Date: 2011-12-15 17:40:17
Message-ID: 20111215184017.18565s5emc5jxxwc@webmail.kwsoft.de (view raw or flat)
Thread:
Lists: pgsql-admin
Zitat von Jan-Peter(dot)Seifert(at)gmx(dot)de:

> Hello Andreas,
>
> thank you very much for the link.
>
> -------- Original-Nachricht --------
>> Datum: Thu, 08 Dec 2011 13:04:30 +0100
>> Von: lst_hoe02(at)kwsoft(dot)de
>> Zitat von Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)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_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware
>
>> 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


In response to

Responses

pgsql-admin by date

Next:From: Khusro JaleelDate: 2011-12-15 18:02:03
Subject: Issues with log-shipping replication
Previous:From: P RDate: 2011-12-15 16:01:24
Subject: Resuming Incomplete Pg-restore Tasks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group