Write k6 tests for various parts of the system

[mostafa]

Prerequisite

1. 2 AWS EC2 m7i.48xlarge instances

   Compute	Value
   vCPUs	192
   Memory (GiB)	768.0
   Memory per vCPU (GiB)	4.0
   Physical Processor	Intel Xeon Scalable (Sapphire Rapids)
   Clock Speed (GHz)	3.2
   CPU Architecture	x86_64

2. Grafana + Prometheus installed on both of the instances to collect PostgreSQL and Linux system metrics

3. GatewayD v0.8.4 installed on one of the instances

4. PostgreSQL v16.0 installed on one of the instances

5. Grafana dashboards for PostgreSQL and Linux system metrics

Resources

• https://github.com/pg-sharding/spqr/blob/master/docs/Benchmarks.md
• https://blog.rustprooflabs.com/2017/12/psql-load-test
• https://blog.lawrencejones.dev/building-a-postgresql-load-tester/
• https://www.hammerdb.com/
  • https://github.com/TPC-Council/HammerDB
  • https://www.hammerdb.com/docs/
  • https://www.hammerdb.com/benchmarks.html
  • https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/ba-p/3254918
  • https://cloud.google.com/compute/docs/tutorials/load-testing-sql-server-hammerdb
• https://www.cybertec-postgresql.com/en/bulk-load-performance-in-postgresql/
• https://techcommunity.microsoft.com/t5/apps-on-azure-blog/load-testing-databases-with-azure-load-testing/ba-p/3846557

Tasks

• [ ] #354
• [ ] #355
• [ ] #356