"125_connections" - this is a problem related to "older" PG versions (and in my own experience, the number is closer to 230, not 125), and I believe it was fixed in newer versions.
Besides, it's much more efficient to use connection pulling (PgBouncer, PgPool), when dealing with that many connections. For last 5 years we are running PG on many, many (hundreds) servers under WIN, and we have no complains regarding PG stability. Regards, Igor Neyman From: Serge Fonville [mailto:serge.fonvi...@gmail.com] Sent: Friday, February 24, 2012 11:07 AM To: mgo...@isstrucksoftware.net Cc: Durumdara; pgsql-general@postgresql.org Subject: Re: Stability in Windows? Doesn't http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Nat ive_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C _despite_having_capable_hardware apply? Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Google!! They need to add GAL support on Android (star to agree) http://code.google.com/p/android/issues/detail?id=4602 2012/2/24 Serge Fonville <serge.fonvi...@gmail.com> Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Google!! They need to add GAL support on Android (star to agree) http://code.google.com/p/android/issues/detail?id=4602 2012/2/24 <mgo...@isstrucksoftware.net> We are using it on a rather beefy server with no problems with a Win32 client/server app. There are additonal things you can do to tune the database. I've not seen any stability problems. Remember it's been several years since version 8 came out and the current version is 9.1.2. Michael Gould Intermodal Software Solutions, LLC 904-226-0978 -------- Original Message -------- Subject: [GENERAL] Stability in Windows? From: Durumdara <durumd...@gmail.com> Date: Fri, February 24, 2012 8:39 am To: pgsql-general@postgresql.org Hi! We planned to port some very old DBASE db into PGSQL. But somebody said in a developer list that he tried with PGSQL (8.x) and it was very unstable in Windows (and it have problem when many users use it). Another people also said that they used PGSQL only in Linux - and there is no problem with it, only some patches needed for speeding up writes... What is your experience in this theme? Do you also have same experience in Windows? The user number is from 20 to up 100 (concurrently). Thanks for your every idea, help, link, information about this. Regards: dd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
