#Sql

For some background - postgresql performs best with ~2 connections per core. Having more than this number of connections will just create contention and significantly slow down the benchmark result. Greg Lowe 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. wiki. [Read More]