DarkAngelStrike
DarkAngelStrike
/ huge_pages_pg_calc.sh
Created
March 10, 2022 17:30
— forked from AlexBaranowski/huge_pages_pg_calc.sh
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}') |