Max. number of concurrent user in PostGre database
-
Hi All, Can anybody plz. answer what is the maximum number of concurrent user in PostGre database (with current version or any previous)? Your reply is highly awaiting. Thanks in advance! With Regards, Navin Pandit Mail:navin2k6@gmail.com Gurgaon, (India)
-
Hi All, Can anybody plz. answer what is the maximum number of concurrent user in PostGre database (with current version or any previous)? Your reply is highly awaiting. Thanks in advance! With Regards, Navin Pandit Mail:navin2k6@gmail.com Gurgaon, (India)
You can define the maximum number of connections. Refer to: http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html[^] and max_connections (integer)
The need to optimize rises from a bad design.My articles[^]
-
You can define the maximum number of connections. Refer to: http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html[^] and max_connections (integer)
The need to optimize rises from a bad design.My articles[^]
Many thanks Mika for your quick reply, but this determines the max. number of connection currently established with the server. Actually I want to know the max. number of possible concurrent users, beyond that number database may not listen about the user/request. I am not sure but in some forum it was mentioned around 12000. Is there any such number of possible users? Regards, Navin
-
Many thanks Mika for your quick reply, but this determines the max. number of connection currently established with the server. Actually I want to know the max. number of possible concurrent users, beyond that number database may not listen about the user/request. I am not sure but in some forum it was mentioned around 12000. Is there any such number of possible users? Regards, Navin
Sorry, but I don't quite follow. From the settings documentation: "Determines the maximum number of concurrent connections to the database server...This parameter can only be set at server start" So my understanding is that with this startup parameter you define the maximum number of concurrent connections that can be taken to the server (well actually max_connections-superuser_reserved_connections). As far as I know, the actual maximum you can define is operating system dependent. The setting itself is defined in postgresql.conf.
The need to optimize rises from a bad design.My articles[^]
-
Many thanks Mika for your quick reply, but this determines the max. number of connection currently established with the server. Actually I want to know the max. number of possible concurrent users, beyond that number database may not listen about the user/request. I am not sure but in some forum it was mentioned around 12000. Is there any such number of possible users? Regards, Navin
Navin C. Pandit wrote:
Actually I want to know the max. number of possible concurrent users, beyond that number database may not listen about the user/request.
You are mixing terms. User != connections. A connection represents a TCP connection to the database. A "user", say for example a real person running a GUI can have 1 or more connections to a database.
-
Navin C. Pandit wrote:
Actually I want to know the max. number of possible concurrent users, beyond that number database may not listen about the user/request.
You are mixing terms. User != connections. A connection represents a TCP connection to the database. A "user", say for example a real person running a GUI can have 1 or more connections to a database.
Many thanks for your nice reply Jschell! Sorry, unfortunately I wrote the term connection. My focus is about to max. possible number of database concurrent user only. Thanks,
-
Many thanks for your nice reply Jschell! Sorry, unfortunately I wrote the term connection. My focus is about to max. possible number of database concurrent user only. Thanks,