supabase / supavisor

A cloud-native, multi-tenant Postgres connection pooler.
https://supabase.github.io/supavisor/
Apache License 2.0
1.73k stars 55 forks source link

Github Action for automatically running pgbench #11

Open chasers opened 1 year ago

J0 commented 1 year ago

Hey

Quick check: for this issue what would happen to the logs after running PGPASSWORD=postgres pgbench -M extended --transactions 100 --jobs 10 --client 100 -h localhost -p 7654 -U postgres.localhost postgres or similar?

Would it be piped somewhere or would it remain in the CI logs in case anyone wanted to inspect that changes are not affecting the performance of Supavisor too much.

If it's still relevant at all I mean

abc3 commented 1 year ago

It's very relevant! As for the implementation, we can store the result in the CI and compare the transactions per second (TPS) result with a threshold value, which is stored as a GA variable