One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
AlexBaranowski
/ huge_pages_pg_calc.sh
Created
February 1, 2019 16:54
Simple script to calculate huge pages for PostgreSQL. Please note that this is baseline and require further tunning.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env bash | |
| [ -z "$PGDATA" ] && echo "PGDATA is not defined!" && exit 1 | |
| [ ! -e $PGDATA/postmaster.pid ] && echo "Cannot find $PGDATA/postmaster.pid is PostgreSQL server running?" && exit 1 | |
| PG_PID=$(head -1 $PGDATA/postmaster.pid) | |
| PG_MEM_U=$(grep ^VmPeak /proc/$PG_PID/status | awk '{print $3}') | |
| HP_MEM_U=$(grep ^Hugepagesize /proc/meminfo | awk '{print $3}') | |
| [ "$PG_MEM_U" != "$HP_MEM_U" ] && echo "The units differ please calculate the Huge Pages manually" && exit 1 | |
| PG_MEM=$(grep ^VmPeak /proc/$PG_PID/status | awk '{print $2}') | |
| HP_MEM=$(grep ^Hugepagesize /proc/meminfo | awk '{print $2}') |
As configured in my dotfiles.
start new:
tmux
start new with session name: