All work
- Reviewing default wal_level parametrizationK8SPG-779ege.gunes
- Using empty repo name in finalizer on backup restore.K8SPG-778
- Auto-set crVersion if not defined in CRK8SPG-777
- Cleanup PMM2 related functionalityK8SPG-775
- kubectl scale FunctionalityK8SPG-774
- Align labels with Kubernetes recommended label conventionsK8SPG-773Andrii Dema
- Nil pointer on getLatestBackupsK8SPG-772natalia.marukovich
- [Investigate] Adding support of PVC snapshotsK8SPG-771
- Add Support for PVC SnapshotsK8SPG-770
- Allow annotations for jobs created by the operator for meshed environmentsK8SPG-769
- Support for custom extensions from a dedicated PVC instead of S3K8SPG-767
- Documentation needs to be more clear on the need to manually update pg_stat_monitor extensionK8SPG-766Anastasia Alexandrova
- Upgrading PostgreSQL image from 15.7 to 15.12 causes segmentation fault (due to pg_stat_monitor)K8SPG-765Resolved issue: K8SPG-765
- Use official PG distribution docker imagesK8SPG-764Resolved issue: K8SPG-764
- Validate instructions in docsK8SPG-763Anastasia Alexandrova
- Building a troubleshooting imageK8SPG-762Slava Sarzhan
- Add PGO_WORKERS functionalityK8SPG-761ege.gunes
- Documentation error on cluster-wide deployement WATCH_NAMESPACEK8SPG-760Anastasia Alexandrova
- Add s3 ForcePathStyle support for custom extensionsK8SPG-759
- Add Pprof binding to the controllerK8SPG-758
- The Patroni version check pod is failing to start if readOnlyRootFilesystem is enforced.K8SPG-757
- Add e2e test for built-in extensionsK8SPG-755
- Certify Percona Operator for PostgreSQL 2.6.0 for the latest version of OpenshiftK8SPG-754Resolved issue: K8SPG-754Julio Pasinatto
- Add ability to enable pg_stat_statements instead of pg_stat_monitorK8SPG-753Eleonora Zinchenko
- Allow setting loadBalancerClassK8SPG-752
- Secrets are recreated on deletion with delete-pvc finalizerK8SPG-751
- Enable users to change cluster label for pmm-adminK8SPG-750Julio Pasinatto
- kubectl delete pg cluster does not appear to delete everythingK8SPG-749Resolved issue: K8SPG-749
- PerconaPGCluster status improvementsK8SPG-748
- Fix PVC resizing status handling in PostgresCluster controllerK8SPG-747
- Migrate to aws-sdk-go-v2 from aws-sdk-goK8SPG-746
- Support Sidecar containers which will be GA from K8s 1.33K8SPG-745
- Document how to build operator for contributorsK8SPG-744dmitriy.kostiuk
- Disable client-side throttling in go-clientK8SPG-743Slava Sarzhan
- "ERROR failed to cleanup outdated backups" during pillar minor upgradeK8SPG-740
- Inconsistent update of PostgresCluster & PG generationK8SPG-739
- Add startup log to print commit hash, branch and build timeK8SPG-738Eleonora Zinchenko
- datadir stats are not accessible by node_exporter in PostgreSQL podsK8SPG-737George Kechagias
- [DOCU] - Missing docummentationK8SPG-736Anastasia Alexandrova
- Release 2.5.1K8SPG-735Resolved issue: K8SPG-735Eleonora Zinchenko
- Update Jenkinsfile to use 1.29 cluster versionK8SPG-734Resolved issue: K8SPG-734
- [Docu] - Missing documentation on certified image for different versions of operatorK8SPG-733Resolved issue: K8SPG-733Eleonora Zinchenko
- pgbackrest debug logs is hard to readK8SPG-732Eleonora Zinchenko
- Zero downtime major upgrades for PostgreSQLK8SPG-731
- Add status.observedGeneration Field to Percona PG ClusterK8SPG-730
- Add Label for CRDK8SPG-729natalia.marukovich
- Configure s3 to support minioK8SPG-728
- Can't connect to a DB created from template0K8SPG-727
- Add securityContext for all sidecarsK8SPG-726Julio Pasinatto
- Add Support for Configuring repo-host Resources in Percona Postgres Custom ResourceK8SPG-725Julio Pasinatto
50 of 659
Reviewing default wal_level parametrization
General
Escalation
General
Escalation
Description
Environment
None
Details
Details
Assignee
ege.gunes
ege.gunesReporter
Pablo Svampa
Pablo SvampaNeeds QA
Yes
Fix versions
Priority
Created 4 hours ago
Updated 3 hours ago
Based on a customer's question, we found:
From PostgreSQL viewpoint,
wal_level
default value isreplica
.Altought setting it to
logical
is more flexible and allows customers to set up logical replication without additional changes (absolutely questionable because you might require to review/setmax_wal_senders
,wal_keep_size
/wal_keep_segments
,max_replication_slots
, etc ), this comes with performance disadvantages for those who do not use logical replication (the majority of cases)I never benchmarked this área, but in theory, this modification increases the amount of information in the WAL segments. So, more storage needs, more IO needs, more CPU to address the IO, more network usage when using S3 buckets. Additionally, it should come with some additional penalization to the DB performance because every UPDATE/DELETE requires including more information in the WAL segments.
Best regards,