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.