From 9d6688ef7108ff9ed2044ba3a03204e035e57e7c Mon Sep 17 00:00:00 2001 From: Grant Slater Date: Sun, 31 Aug 2025 04:59:57 +0100 Subject: [PATCH] Add azure-01 postgres and cpu/memory tuning --- roles/azure-01.rb | 111 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 111 insertions(+) diff --git a/roles/azure-01.rb b/roles/azure-01.rb index d878c962b..745d265cf 100644 --- a/roles/azure-01.rb +++ b/roles/azure-01.rb @@ -21,6 +21,117 @@ default_attributes( } } }, + :postgresql => { + :settings => { + :defaults => { + :effective_cache_size => "16GB" + } + } + }, + :sysfs => { + :cpu_power_energy_perf_bias => { + :parameters => { + "devices/system/cpu/cpu0/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu1/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu2/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu3/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu4/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu5/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu6/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu7/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu8/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu9/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu10/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu11/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu12/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu13/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu14/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu15/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu16/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu17/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu18/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu19/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu20/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu21/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu22/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu23/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu24/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu25/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu26/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu27/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu28/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu29/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu30/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu31/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu32/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu33/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu34/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu35/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu36/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu37/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu38/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu39/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu40/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu41/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu42/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu43/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu44/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu45/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu46/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu47/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu48/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu49/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu50/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu51/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu52/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu53/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu54/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu55/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu56/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu57/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu58/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu59/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu60/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu61/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu62/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu63/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu64/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu65/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu66/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu67/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu68/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu69/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu70/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu71/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu72/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu73/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu74/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu75/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu76/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu77/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu78/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu79/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu80/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu81/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu82/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu83/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu84/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu85/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu86/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu87/power/energy_perf_bias" => "0", + "devices/system/cpu/cpu88/power/energy_perf_bias" => "0" + } + } + }, + :sysctl => { + :postgres => { + :comment => "Increase shared memory for postgres", + :parameters => { + "kernel.shmmax" => 9 * 1024 * 1024 * 1024, + "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096 + } + } + }, :tile => { :styles => { :default => { -- 2.39.5