kmoppel

#!/bin/bash

# PS Running in CRON mode - meaning output produced only on errors

# Expected inputs:
# 1) the pgbackrest config file path, e.g. /etc/pgbackrest/15/main/pgbackrest.conf
# 2) the stanza name
# 3) max age threshold in seconds of last valid backup.
#    errors if no valid backup within the threshold

kmoppel

#!/bin/bash

set -euo pipefail

SCALE=1200
FF=80
UNLOGGED="unlogged"  # set to "" for normal tables
UNLOGGED=""
ROW_CHANGES=100000  # 0.1% of scale 1000

kmoppel

import psycopg
import random
import time

CONNSTR = "postgresql://james:[email protected]:5432/postgres?sslmode=require"
SCALE = 10
BASE_SQL = """
BEGIN;
SELECT abalance FROM pgbench_accounts WHERE aid = {aid};
SELECT abalance FROM pgbench_accounts WHERE aid = {aid2};

kmoppel

#!/usr/bin/env python3

import time
import psycopg
from psycopg.rows import dict_row
from datetime import datetime


CONNSTR = "dbname=postgres user=postgres port=5434"

kmoppel

\set QUIET on
\pset linestyle unicode
\pset null ¤
;\set PROMPT1 '%n@%/=%#%x '
\pset pager on
\x auto
\set HISTCONTROL ignoreboth
\set HISTSIZE 10000
\set HISTFILE ~/.psql_history- :DBNAME
\set PSQL_EDITOR 'vim -c ":set ft=sql"'

kmoppel

/* ON PROD DB */

CREATE TEMP TABLE exported_stats AS
select
schemaname,
tablename,
attname,
null_frac,
avg_width,
n_distinct,

kmoppel

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.4 (Ubuntu 17.4-1.pgdg24.04+2)
-- Dumped by pg_dump version 17.4 (Ubuntu 17.4-1.pgdg24.04+2)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;

kmoppel

kmoppel

--- DROP TABLE IF EXISTS customer, product, payment_method, "order", order_item CASCADE ;

CREATE TABLE customer (
    customer_id BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    name TEXT NOT NULL,
    dob DATE NOT NULL,
    email TEXT UNIQUE NOT NULL,
    created_on TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

kmoppel