Test cross platform `pgroll` builds in the CI workflow (#525) #102

	name: Benchmark
	on:
	workflow_dispatch:
	push:
	branches:
	- main
	permissions:
	id-token: write # For getting AWS permissions
	contents: read
	packages: read
	jobs:
	benchmark:
	name: 'benchmark (pg: ${{ matrix.pgVersion }})'
	runs-on: ubuntu-24.04
	strategy:
	fail-fast: false
	matrix:
	pgVersion: ['14.8', '15.3', '16.4', '17.0' ,'latest']
	steps:
	- uses: actions/checkout@v4

	- name: Set up Go
	uses: actions/setup-go@v5
	with:
	go-version-file: 'go.mod'

	- name: Run benchmarks
	run: make bench
	env:
	POSTGRES_VERSION: ${{ matrix.pgVersion }}

	- name: Upload results
	uses: actions/upload-artifact@v4
	with:
	name: benchmark_result_${{ matrix.pgVersion }}.json
	path: internal/benchmarks/benchmark_result_${{ matrix.pgVersion }}.json

	gather:
	name: 'Gather results'
	runs-on: ubuntu-24.04
	needs: [benchmark]

	steps:
	- uses: actions/download-artifact@v4
	with:
	path: ./results/
	merge-multiple: true

	- name: Configure AWS Credentials
	uses: aws-actions/configure-aws-credentials@v2
	with:
	role-to-assume: arn:aws:iam::493985724844:role/pgroll-benchmark-results-access
	aws-region: us-east-1
	mask-aws-account-id: 'no'

	- name: Download current results from S3
	run: aws s3 cp s3://pgroll-benchmark-results/benchmark-results.json ./benchmark-results.json

	- name: Append new results
	run: cat results/*.json >> benchmark-results.json

	- name: Upload combined results
	run: aws s3 cp ./benchmark-results.json s3://pgroll-benchmark-results/benchmark-results.json

Provide feedback