Peter Bendel 43dc03459d Run pgbench on 10 GB scale factor on database with n relations (e.g. 10k) (#10172) ...

## Problem

We want to verify how much / if pgbench throughput and latency on Neon
suffers if the database contains many other relations, too.

## Summary of changes

Modify the benchmarking.yml pgbench-compare job to
- create an addiitional project at scale factor 10 GiB
- before running pgbench add n tables (initially 10k) to the database
- then compare the pgbench throughput and latency to the existing
pgbench-compare at 10 Gib scale factor

We use a realistic template for the n relations that is a partitioned
table with some realistic data types, indexes and constraints - similar
to a table that we use internally.

Example run:
https://github.com/neondatabase/neon/actions/runs/12377565956/job/34547386959

2024-12-19 10:25:44 +00:00

..

create_many_relations.sql

Run pgbench on 10 GB scale factor on database with n relations (e.g. 10k) (#10172)

2024-12-19 10:25:44 +00:00