aei-tech
/ huge_pages_pg_calc.sh
Last active
February 15, 2025 23:18
— 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 hidden or 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}') |
aei-tech
/ change_db_owner.sh
Last active
December 8, 2024 21:01
— forked from gingerlime/change_db_owner.sh
Postgresql - Changing ownership on all tables
This file contains hidden or 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
| #!/bin/bash | |
| usage() | |
| { | |
| cat << EOF | |
| usage: $0 options | |
| This script set ownership for all table, sequence and views for a given database | |
| Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto |