Starting to size TPC-E database on r5b.4xlarge instance type on minimum scale factor of 5000 customer. PostgreSQL can serve 148 Trade Results per second suggesting this system can support somewhere between 5000 and 75,000 customers. Narrowing it down...

Sizing up r5b.4xlarge instance type for TPC-E-like workload. Some grossly set PostgreSQL GUCs to start: shared_buffers = 16GB, effective_io_concurrency = 200, max_wal_size = 500GB, random_page_cost = 1.0, checkpoint_timeout = 30min

Containerized DBT-7 (Fair Use TPC Benchmark(TM) DS): docker pull ghcr.io/osdldbt/dbt7:latest

pg_plan_advice differences with enable_nestloop off for TPC-DS queries gist.github.com/markwkm/3775...

Compare pg_plan_advice DBT-7 / TPC-DS SF 1

Compare pg_plan_advice DBT-7 / TPC-DS SF 1. GitHub Gist: instantly share code, notes, and snippets.

gist.github.com