CI: Add interruptible jobs, auto-cancel, and reduce MR test matrix

Nikolay Samokhvalovrequested to merge
ci/interruptible-auto-cancel into master

Summary

1. Auto-cancel redundant pipelines

  • Add workflow.auto_cancel.on_new_commit: interruptible to automatically cancel old pipelines when new commits are pushed
  • Set default.interruptible: true so all build/test jobs can be cancelled
  • Mark release and RC build jobs as interruptible: false to ensure production releases complete

2. Reduce MR test matrix (80% queue time reduction)

  • Run only PG 17 and PG 18 for MR pipelines (2 instead of 10 versions)
  • Main branch pipelines still run full matrix (PG 9.6-18) for comprehensive coverage
  • Expected to save ~28 minutes per MR pipeline

Problem

The bash-test jobs run on self-hosted shell runners with only 2 runners available. With 10 test jobs competing for 2 runners, queue times reach up to 19+ minutes for later jobs.

Expected Impact

  • 80% reduction in integration test queue time for MRs
  • Reduced runner waste when multiple commits are pushed quickly
  • Faster feedback for developers
  • Cleaner pipeline history

Closes #670 (closed), Closes #671 (closed)

Edited by Nikolay Samokhvalov

Merge request reports