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_connectionsetting of 500
Or am I missing something here. Thanks!!