Re: Stability in Windows? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Stability in Windows?
Date
Msg-id CAOR=d=0UqcgnuBneHR0aBMx5Ocib6hj6acvKa63jkRVZkzus=g@mail.gmail.com
Whole thread Raw
In response to Re: Stability in Windows?  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-general
On Fri, Feb 24, 2012 at 12:58 PM, Igor Neyman <ineyman@perceptron.com> wrote:
> “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.

Agreed.  Note that in some big environments you're using pgbouncer to
reduce thousands of connections to a few hundred.  In those instances.
 At that point having 40+ cores and running on unix becomes necessary
for performance with pgsql.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Re: When I try to connect to a database, I get the following error : psql teleflowdb8
Next
From: Scott Marlowe
Date:
Subject: Re: Maxium Share Memory in Debian 64bit