Re: Profiling PostgreSQL - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: Profiling PostgreSQL
Date
Msg-id CAJghg4+Ldg4iV=Q5JahYd=8Cs-dD=QdN+=VdKweHHu4+sDxgag@mail.gmail.com
Whole thread Raw
In response to Re: Profiling PostgreSQL  (Dimitris Karampinas <dkarampin@gmail.com>)
List pgsql-performance

On Sun, May 25, 2014 at 1:26 PM, Dimitris Karampinas <dkarampin@gmail.com> 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 environemnt and recent version of Linux kernel, you should try to disable vm.zone_reclaim_mode, as it seems to cause performance degradation for database workloads, see [1] and [2].
Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

pgsql-performance by date:

Previous
From: Dimitris Karampinas
Date:
Subject: Re: Profiling PostgreSQL
Next
From: Albe Laurenz
Date:
Subject: NFS, file system cache and shared_buffers