On Wed, Aug 17, 2011 at 9:52 PM, Navin Chandra <navin.pandit@xxxxxxxxxxxxxxxxxxxx> wrote: > Hi, > > I am an application developer, want to use ‘PostGre’ as backend. May I know > what is the maximum possible number of concurrent users? > Your acknowledgement will be highly appreciated. FYI, we call it PostgreSQL or pgsql around here. The maximum number you can create is much more than the maximum number you like want to create. What are you looking at doing? Might connection pooling be a good match for that? I have session db servers that keep ~800 persistent connections open for small single table queries and they do just fine. I've tested thousands of connections with decent performance. However having lots of open connections can lead to "thundering herd" problems and is generally suboptimal. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
