PostgreSQL Performance: Is Your Query Slow or Just Long-Running?
PostgreSQL performance issues fall into two distinct categories: slow queries caused by inefficient execution, and long-running queries that simply process large workloads. Slow queries consume excess CPU and I/O due to missing indexes, bad statistics, or poor join strategies, while long-running queries may be appropriate for batch ETL or reporting tasks. The article stresses that only business stakeholders can decide if a query warrants tuning, as premature optimization can add unnecessary indexes and operational risk. Recognizing the difference guides DBAs toward proper tuning or workload scheduling.
Deploying Cross-Site Replication in Percona Operator for MySQL (PXC)
The article walks through configuring cross‑site disaster‑recovery for Percona XtraDB Cluster (PXC) using the Percona Operator for MySQL in Kubernetes. It details a three‑node primary cluster, exposing nodes via LoadBalancer services, taking an S3‑backed backup, and restoring it on a...
Why A Goat?
Percona announced a bold rebrand, unveiling a goat as its new mascot to embody the company’s focus on resilience, independence and practical problem‑solving. The change is not a product shift but a visual statement of 20 years of open‑source database expertise...
How to Customize PagerDuty Custom Details in Grafana: The Hidden Override Method
Grafana’s native PagerDuty integration dumps every alert label and annotation into the incident details, creating unreadable payloads. By adding a custom key named "firing" in the contact point’s Details section, users can override the default template and send only essential...
A Failing Unit Test, a Mysterious TCMalloc Misconfiguration, and a 60% Performance Gain in Docker
Percona Server for MongoDB 8.0.16‑5 uncovered a Docker‑specific failure in the tcmalloc_set_parameters_test, where the allocator reported zero capacity due to misreading the cgroup v2 "max" limit. The root cause was a code change that swapped Mongo’s NumberParser for the standard atoll...
Percona Operator for MongoDB 1.22.0: Automatic Storage Resizing, Vault Integration, Service Mesh Support, and More!
Percona released Operator for MongoDB version 1.22.0, adding automatic Persistent Volume Claim resizing, HashiCorp Vault integration for system user credentials, and native service‑mesh compatibility via the appProtocol field. The update also expands backup and restore capabilities, including replica‑set name remapping,...