Postgres DBA

Полезные скрипты, непосредственно не относящиеся к pg_expecto. compare/compare.sh Сравнение конфигурационных файлов СУБД (формат ключ = значение). mask_pgpro_pwr/mask_pgpro_pwr.sh Маскирование IP, констант в SQL-запросах и имён баз данных в отчётах pgpro_pwr. vacuum/vacuum Сервисные скрипты для ручного выполнения VACUUM для отдельных таблиц в кластере. pg-expecto/pg_ai_helpers: These scripts are AI‑generated utilities for PostgreSQL administration and are not part of pg_expecto.

Публикация о pg_expecto на казахском ресурсе astanahub: [PostgreSQL] Почему "все тормозит" https://astanahub.com/ru/blog/postgresql-pochemu-vse-tormozit

-- scenario1.sql UPDATE CREATE OR REPLACE FUNCTION scenario1() RETURNS integer AS $$ DECLARE  test_rec record ;  min_i bigint ;  max_i bigint ;  current_aid bigint ;  current_tid bigint ;  current_bid bigint ;  current_delta bigint ;  counter bigint; BEGIN current_delta = (ROUND( random ())::bigint)*10 + 1 ; SELECT MIN(aid) INTO min_i FROM pgbench_accounts ; SELECT MAX(aid) INTO max_i FROM pgbench_accounts ; current_aid = floor(random() * (max_i - min_i + 1)) + min_i ; UPDATE pgbench_accounts SET abalance = abalance + current_delta WHERE aid = current_aid ; SELECT abalance INTO test_rec FROM pgbench_accounts WHERE aid = current_aid ; SELECT MIN(tid) INTO min_i FROM pgbench_tellers ; SELECT MAX(tid) INTO max_i FROM pgbench_tellers ; current_tid = floor(random() * (max_i - min_i + 1)) + min_i ; UPDATE pgbench_tellers SET tbalance = tbalance + current_delta WHERE tid = current_tid ; SELECT MIN(bid) INTO min_i FROM pgbench_branches ; SELECT MAX(bid) INTO max_i FROM pgbench_branches ; current_bid = floor(random() * (max_i - min_i + 1)) + min_i ; UPDATE pgbench_branches SET bbalance = bbalance + current_delta WHERE bid = current_bid ;  return 0 ; END $$ LANGUAGE plpgsql;