Without diving so much into web applications or database performance tuning etc, I wish to consult on one thing. pgBouncer has the following settings:
;; Total number of clients that can connect
max_client_conn = 5000
;; Default pool size. 20 is good number when transaction pooling
;; is in use, in session pooling it needs to be the number of
;; max clients you want to handle at any moment
default_pool_size = 500
Given that the web application I am running can only operate in session
mode, is the configuration above correct assuming:
- My web application does not go above the 5000 client connection mark
- My PostgreSQL Database has a
max_connection
setting of 500
Or am I missing something here. Thanks!!