Hello Andreas, thank you very much for the link. -------- Original-Nachricht -------- > Datum: Thu, 08 Dec 2011 13:04:30 +0100 > Von: lst_hoe02@xxxxxxxxx > Zitat von Jan-Peter Seifert <Jan-Peter.Seifert@xxxxxx>: > > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
