Hi,
I would like to understand how to calculate optimal value for “pool” parameter in database.yml
I’m using rails 3, ruby 2, postgres, elasticsearch, unicorn, nginx
My server : 12 coeurs 24 threads ( I dont know if it is necessary for define pool value)
unicorn : worker_processes 24
I have around 1500 pages requested per minutes, and around 200ms per request
Is it also useful/necessary to use this ?
allow_concurrency: true
thanks
Hi,
I would like to understand how to calculate optimal value for “pool” parameter in database.yml
I’m using rails 3, ruby 2, postgres, elasticsearch, unicorn, nginx
My server : 12 coeurs 24 threads ( I dont know if it is necessary for define pool value)
unicorn : worker_processes 24
I have around 1500 pages requested per minutes, and around 200ms per request
Unicorn only dispatches one request at a time to each worker, so the pool setting doesn’t matter: each worker will only process one request at a time
Your numbers suggest you can do 5 requests per second per worker, ie 300 per minute per worker, so it seems that you have ample resources. However you’ll probably need to do some testing to confirm this as it would only be true if CPU is your bottleneck (as opposed to database concurrency for example)
Is it also useful/necessary to use this ?
allow_concurrency: true
not sure what that is without some context.
Fred