On 10/22/2013 10:59 AM, Stephen Frost wrote:
PG is really*much* happier if you have only one backend per CPU in your system. The way to get there is by using a connection pooler like pg_bouncer and configuring it based on how many CPUs you have.
Actually, I've found peak throughputs on a decent multicore server with lots of ram, and lots of disk IO parallelism (eg, big raid10) is aruond 2X the socket*hyperthread*core count... so for instance, on a modern 2 socket E5-2665 kind of server, thats 2 x 8 cores with 2 threads per core, thats 16 total cores, 32 total hardware threads, so about 64 database connections would be peak, given a decent raid10 of lots of SAS2 10k/15k disks
-- john r pierce 37N 122W somewhere on the middle of the left coast