Re: Profiling PostgreSQL

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Profiling PostgreSQL
Дата
Msg-id CAJghg4+Ldg4iV=Q5JahYd=8Cs-dD=QdN+=VdKweHHu4+sDxgag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Profiling PostgreSQL  (Dimitris Karampinas <dkarampin@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dimitris Karampinas
Дата:
Сообщение: Re: Profiling PostgreSQL
Следующее
От: Albe Laurenz
Дата:
Сообщение: NFS, file system cache and shared_buffers