Charmed PostgreSQL K8s
- Canonical
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 20 | 20 Sep 2022 | |
14/stable | 445 | Yesterday | |
14/stable | 444 | Yesterday | |
14/candidate | 382 | 09 Sep 2024 | |
14/candidate | 381 | 09 Sep 2024 | |
14/beta | 449 | Yesterday | |
14/beta | 448 | Yesterday | |
14/edge | 451 | Yesterday | |
14/edge | 450 | Yesterday |
juju deploy postgresql-k8s --channel 14/edge
Deploy Kubernetes operators easily with Juju, the Universal Operator Lifecycle Manager. Need a Kubernetes cluster? Install MicroK8s to create a full CNCF-certified Kubernetes system in under 60 seconds.
Platform:
Performance and resource allocation
This page covers topics related to measuring and configuring the performance of PostgreSQL
Performance testing
For performance testing and benchmarking charms, we recommend using the Charmed Sysbench operator. This is a tool for benchmarking database applications that includes monitoring and CPU/RAM/IO performance measurement.Resource allocation
Charmed PostgreSQL K8s resource allocation can be controlled via the charm’sprofile
config option. There are two profiles: production
and 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 behavior).The max_connections =max(4 * os.cpu_count(), 100).Use pgbouncer if max_connections are not enough (reasoning). |
testing |
Minimal resource usage | PostgreSQL 14 defaults. |
Note: Pre-deployed application profile change is planned but currently is NOT supported.
You can set the profile during deployment using the --config
flag. For example:
juju deploy postgresql-k8s --trust --config profile=testing
You can change the profile using the juju config
action. For example:
juju config postgresql-k8s profile=production
For a list of all of this charm’s config options, see the Configuration tab.
Juju constraints
The Juju --constraints
flag sets RAM and CPU limits for Kubernetes pods:
juju deploy postgresql-k8s --trust --constraints cores=8 mem=16G
Juju constraints can be set together with the charm’s profile:
juju deploy postgresql-k8s --trust --constraints cores=8 mem=16G --config profile=testing