Is there an existing issue already for this feature request/idea?

• I have searched for an existing issue, and could not find anything. I believe this is a new feature request to be evaluated.

What problem is this feature going to solve? Why should it be added?

pgbench jobs are not cleaned by default. It would be great to have to possibility to clean them automatically after a certain time.

Describe the solution you'd like

The ttlSecondsAfterFinished option of a Kubernetes Job could be implemented. See https://kubernetes.io/docs/concepts/workloads/controllers/job/#clean-up-finished-jobs-automatically

It could be configured in the YAML file, in a job or pgbench / section . For example for one hour TTL :

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: perf-cluster
spec:
  imageName: ghcr.io/cloudnative-pg/postgresql:16.2
  instances: 1
  pgbench:
    ttlSecondsAfterFinished: '3600'
...

By default, we can keep it disabled.

Describe alternatives you've considered

It could be done as a parameter given at the pgbench plugin.
kubectl cnpg pgbench --ttl 300 .....

Additional context

No response

Backport?

No

Are you willing to actively contribute to this feature?

Yes

Code of Conduct

• I agree to follow this project's Code of Conduct