Postgres DBA

ℹ️Полезные скрипты, непосредстванно не относящиеся к pg_expecto. ☑️compare.sh : сравнение конфигурационных файлов СУБД ( формат ключ = значение) ☑️mask_pgpro_pwr.sh : маскирование ip, констант в SQL запросах и наименований баз данных в отчетах pgpro_pwr pg_expecto/utils at main · pg-expecto/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;