Number Of Database Connections - PostgreSQL wiki

You can often support more concurrent users by reducing the number of database connections and using some form of connection pooling. This page attempts to explain why that is. Summary A database server only has so many resources, and if you don't have enough connections active to use all of them, your throughput will generally improve by using more connections. Once all of the resources are in us

[yass]

" A formula which has held up pretty well across a lot of benchmarks for years is that for optimal throughput the number of active connections should be somewhere near ((core_count * 2) + effective_spindle_count). Core count should not include HT threads, even if hyperthreading is enabled. "

[tmatsuu]

公式にも「(core_count * 2) + effective_spindle_count」って書いてる。