Bill wrote:
> I have been told that the limit on Windows is about 300 concurrent users.
It's actually a good bit worse than that unless you do some very
specific Windows tuning--125. See the last entry at
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows
for details.
Most PostgreSQL installations with a large number of connections benefit
from connection pooling though, which improves this situation
considerably. If you think about it, the server can't actually process
more than a small multiple of its cores worth of useful work at a time
anyway. Above that, you're just adding contention without increasing
total work accomplished. So "how many connections does it support at
once?" is a metric of little value anyway. I can easily generate a
workload that crushes a system with a single connection, or generate one
where connections spend so much time idle that you can scale to enormous
numbers of them.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us