Charmed PostgreSQL

Architecture:

Channel	Revision	Published	Runs on
latest/stable	345	09 Nov 2023	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04
14/stable	336	18 Oct 2023	Ubuntu 22.04
14/candidate	336	18 Oct 2023	Ubuntu 22.04
14/beta	336	18 Oct 2023	Ubuntu 22.04
14/edge	350	Today	Ubuntu 22.04

Platform:

22.04

Share your thoughts on this charm with the community on discourse.

Profiles

Warning: The feature is currently available in the channel 14/edge only (revision 328+) and will be released to the channel 14/stable soon.

Charmed PostgreSQL resource utilization depends on the chosen profile:

juju deploy postgresql --config profile=testing

Value	Description	Tech details
`production` (default)	Maximum performance	25% of the available memory for `shared_buffers` and the remain as cache memory (defaults mimic legacy charm behaviour).
`testing`	Minimal resource usage	PostgreSQL 14 defaults.

Note: Pre-deployed application profile change is planned but currently is NOT supported.

To change the profile, use juju config (see all charm configs):

juju deploy postgresql --config profile=testing && \
juju config postgresql profile=production

Juju constraints allows RAM/CPU limits for Juju units:

juju deploy postgresql --constraints cores=8 mem=16G

Juju constraints can be used together with charm profile:

juju deploy postgresql --constraints cores=8 mem=16G --config profile=testing