Scripts I use when tinkering with Postgres. Contains scripts for downloading Postgres from source, compiling and running in a docker container. Also contains scripts for running sysbench for simple workloads(reads, writes, and read/writes). Can be useful for testing how different Postgres configurations affect performance(queries, transactions etc), when running with Sysbench

This has only been tested on a machine running Ubuntu Linux(specifically Ubuntu jammy, but should probably work on most Ubuntu platforms)

From the Docker docs, these are the supported Ubuntu versions:

Ubuntu Oracular 24.10
Ubuntu Noble 24.04 (LTS)
Ubuntu Jammy 22.04 (LTS)
Ubuntu Focal 20.04 (LTS)

Some requirements are:

1. Make build tool (apt get install make)
2. Docker (can be installed with make install_docker or check the docker page)
3. Sysbench (can be installed with make install_sysbench)

These environment variables would need to be set before running below commands:

1. PORT - port the postmaster will be listening on(default 5432)
2. HOST - IP address of the instance running the Postgres server(default localhost)
3. TABLESIZE - How big the tables for running with Sysbench should be. Each table will have TABLESIZE rows(default 1000000)
4. MY_IP - IP address of the client(must be set before running)
5. VERSION_STR - The version number for image tag e.g for image postgres/test-0.0.3 the VERSION_STR is 0.0.3(default 0.0.1)

Some useful commands:

make build # will download current postgres from source and set up a running postgres container

make sys_prep # will setup requirements for sysbench(creates sbtest user and database) -- requires Sysbench

make sys_read # Runs a simple read only workload -- requires Sysbench

make sys_write # Runs a simple write only workload -- requires Sysbench

make sys_read_write # Runs a simple mix of read and write workloads -- requires Sysbench

If the make sys_prep command fails with error FATAL: Connection to database failed: FATAL: the database system is starting up, give it a second for the database to start then try again

To complete setup for mysql. Get the root dafault password:

docker logs <mysql_container> # Replace mysql_container with the correct container name

With the root password, these queries should be ran:

alter user 'root'@'localhost' identified by 'pass1234';  -- update root password

-- These are needed by sysbench
create user 'sbtest'@'your_ip_address' identified by 'sbtest';
create database sbtest;
grant create, alter, insert, update, delete, select, index on sbtest.* to 'sbtest'@'your_ip_address';

flush privileges; -- reload