Re: NUMA architecture and PostgreSQL - Mailing list pgsql-admin

From Fabricio
Subject Re: NUMA architecture and PostgreSQL
Date
Msg-id BLU103-W30716C44F6E7F8E12A984CFE050@phx.gbl
Whole thread Raw
In response to Re: NUMA architecture and PostgreSQL  ("Marko Kreen" <markokr@gmail.com>)
List pgsql-admin

Hi Marko, thanks for your help...
 
> There is a bit higher level concept of cpusets too:
>
> http://www.kernel.org/doc/man-pages/online/pages/man7/cpuset.7.html
>

> In both cases, you can either patch Postgres or write a launcher
> that configures CPUs before executing postgres.

This paragraph is the liks of cpuset:
       On systems with kernels compiled with built in support for cpusets, all
processes are attached to a cpuset, and cpusets are always present. If a
system supports cpusets, then it will have the entry nodev cpuset in the file
/proc/filesystems. By mounting the cpuset file system (see the EXAMPLE
section below), the administrator can configure the cpusets on a system to
control the processor and memory placement of processes on that system. By
default, if the cpuset configuration on a system is not modified or if the
cpuset file system is not even mounted, then the cpuset mechanism, though
present, has no affect on the system's behavior.

Do I need to mount the cpuset file system for use numactl?

Example:
numactl --membind=1 su - postgres -c "/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data/"

The two liks are about programing, but can I use only numactl with postgres?

thanks  marko...



¿Tus fotos son un desorden? La solución a tus males se llama Galería fotográfica de Windows Live

pgsql-admin by date:

Previous
From: Fabricio
Date:
Subject: Re: NUMA architecture and PostgreSQL
Next
From: Abdul Rahman
Date:
Subject: Re: PgAgent Job Scehduler is NOT running