Skip to content

A PostgreSQL extension to manage cgroup (Control Group)

Notifications You must be signed in to change notification settings

MasahikoSawada/pg_cgroup

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pg_cgroup

A PostgreSQL extension to manage cgroup (Control Group).

Overview

pg_cgroups provides set of SQL-callable functions to manage cgroup on Linux OS. pg_cgroups requires user to create a cgroup for PostgreSQL server in advance. Using pg_cgroup you can both create/delete/set cgroups and classify pids with in the cgroup of PostgreSQL server.

GUC Parameter

  • pg_cgroup.cgroup_name (text)
    • The name of cgroup of which owner is the user who was used for initdb.

Example

Installation

You can install pg_cgroup extension in similar way as other PostgreSQL extensions except for requiring libcgroup-devel package.

  1. Get libcgroup-devel package
$ sudo yum -y libcgroup-devel
  1. Get pg_cgroup source code
$ git clone [email protected]:MasahikoSawada/pg_cgroup.git
  1. Build and Install
$ make USE_PGXS=1
$ sudo make USE_PGXS=1 install

Setup

  1. Create cgroup for PostgreSQL with definition of user and group
$ cgcreate -g cpu,memory,disk:pgsql -t postgres -a postgres
  1. Configuration fo pg_cgroup
$ vi /path/to/postgresql.conf
shared_preload_libraries = 'pg_cgroup'
pg_cgroup.cgroup_name = 'pgsql'
  1. Start PostgreSQL Server
  2. Create EXTENSION
$ psql -c 'CREATE EXTENSION pg_cgroup'

Usage

  • Create new resource group of cpu controller
=# SELECT create_resource_group('test_cg', 'cpu');
 create_resource_group
-----------------------
 t
(1 row)

Now you can see the created new cgroup by using lscgroup or whatever you'd like to use as follows.

$ lscgroup | grep pgsql
cpu,cpuacct:/pgsql/
cpu,cpuacct:/pgsql/test_cg
  • Set parameter of cpu cgroup
=# SELECT set_resource_value('test_cg', 'cpu', 'cpu.cfs_quota_us', 50000);
 set_resource_value
--------------------
 t
(1 row)

Test Platforms

Category Module Name
OS CentOS 7.4
DBMS PostgreSQL 10
Library libcgroup 0.41-13

Copyright

Copyright © 2018- Masahiko Sawada

License

The PostgreSQL License. (same as BSD License)

About

A PostgreSQL extension to manage cgroup (Control Group)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published