Missing performance tuning parameters for pgbackrest

[tushar5526]

pgbackrest by default ships with unoptimized parameters and users are expected to tune the performance. We are missing process-max in the charm and there could be other parameters as I have not checked the supported options extensively. pgbackrest should be fine-tuned in order to allow quick restoration of backups.

Steps to reproduce

1. Deploy DPE juju deploy postgresql --channel 16/edge
2. Configure S3 integrator
3. ssh into one of the Postgres units and check the pgbackrest.conf.

Expected behavior

pgbackrest configuration is fine-tuned based on the VM specs / database size automatically.

Actual behavior

No process-max in pgbackrest.conf after configuring S3

Versions

Operating system:
Ubuntu 24.04

Juju CLI: 3.6.6-genericlinux-amd64

Juju agent: 3.6.6

postgresql     16.9     active      1  postgresql     16/edge   787  no       
s3-integrator           active      1  s3-integrator  1/stable  145  no

LXD: 5.21.3 LTS

Log output

Juju debug log:

Additional context

[syncronize-issues-to-jira]

Thank you for reporting your feedback to us!

The internal ticket has been created: https://warthogs.atlassian.net/browse/DPE-7549.

This message was autogenerated