Re: [PERFORM] Profiling PostgreSQL

2014-05-25 Thread Matheus de Oliveira
On Sun, May 25, 2014 at 1:26 PM, Dimitris Karampinas wrote: > My deployment is "NUMA-aware". I allocate cores that reside on the same > socket. Once I reach the maximum number of cores, I start allocating cores > from a neighbouring socket. I'm not sure if it solves your issue, but on a NUMA env

Re: [PERFORM] Profiling PostgreSQL

2014-05-25 Thread Dimitris Karampinas
Increasing the shared_buffers size improved the performance by 15%. The trend remains the same though: steep drop in performance after a certain number of clients. My deployment is "NUMA-aware". I allocate cores that reside on the same socket. Once I reach the maximum number of cores, I start allo