[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?
From:       Greg Smith <greg () 2ndquadrant ! com>
Date:       2010-07-30 13:17:16
Message-ID: 4C52D0DC.3010903 () 2ndquadrant ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]