Re: Stability in Windows?

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: "Serge Fonville" <serge(dot)fonville(at)gmail(dot)com>, <mgould(at)isstrucksoftware(dot)net>
Cc: "Durumdara" <durumdara(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stability in Windows?
Date: 2012-02-24 19:58:09
Message-ID: F4C27E77F7A33E4CA98C19A9DC6722A208D186FF@EXCHANGE.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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(dot)fonville(at)gmail(dot)com]
Sent: Friday, February 24, 2012 11:07 AM
To: mgould(at)isstrucksoftware(dot)net
Cc: Durumdara; pgsql-general(at)postgresql(dot)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(dot)fonville(at)gmail(dot)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 <mgould(at)isstrucksoftware(dot)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 <durumdara(at)gmail(dot)com>
Date: Fri, February 24, 2012 8:39 am
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-02-24 20:25:18 Re: invalid memory alloc request size 1765277700 Error Question
Previous Message John R Pierce 2012-02-24 19:46:00 Re: Maxium Share Memory in Debian 64bit