Content-Type: text/plain; charset="utf-8"
Date: Tue, 13 Dec 2011 17:15:50 +0100
From: Jan-Peter.Seifert@gmx.de
In-Reply-To: <20111208130430.14653bnpyytz6l6o@webmail.kwsoft.de>
Message-ID: <20111213161550.219250@gmx.net>
MIME-Version: 1.0
References: <20111207124635.45500@gmx.net>
	<20111208130430.14653bnpyytz6l6o@webmail.kwsoft.de>
Subject: Re: Number of connections still limited on Windows 64-bit?
To: lst_hoe02@kwsoft.de, pgsql-admin@postgresql.org
Content-Transfer-Encoding: 8bit

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_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.

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