Performance Benchmarks to Detect Degradation #10
Description
Implement a performance benchmarking system for the Postgres provider to track and detect performance regressions over time.
Requirements:
- Define key operations and scenarios to benchmark.
- Implement reproducible benchmark scripts.
- Integrate with CI/CD to run benchmarks on demand or periodically.
- Provide a way to visualize performance trends over time.
- Define performance thresholds that trigger alerts when exceeded.
Acceptance Criteria:
- Benchmarks can be run locally and in CI.
- Historical data allows for identifying regressions.
- Alerts are generated when performance drops beyond thresholds.
- Documentation exists for running and interpreting benchmarks.