Neues vom PostgreSQL Planet
Esther Minano: Behind the scenes: Speeding up pgstream snapshots for PostgreSQL
Umair Shahid: From 99.9% to 99.99%: Building PostgreSQL Resilience into Your Product Architecture
Most teams building production applications understand that “uptime” matters. I am writing this blog to demonstrate how much difference an extra 0.09% makes.
At 99.9% availability, your system can be down for over 43 minutes every month. At 99.99%, that window drops to just over 4 minutes. If your product is critical to business operations, customer workflows, or revenue generation, those 39 extra minutes of downtime each month can be the difference between trust and churn.
Abhishek Chanda: Running Postgres on Cloudflare Containers
Disclaimer: I work for Cloudflare. The views and opinions expressed in this post are my own and do not necessarily reflect the official policy or position of Cloudflare.
Mankirat Singh: June, BuildFarm and ABIs
Dmitry Dolgov: An example for metrics assisted modeling of database performance
Jan Wieremjewicz: The PG_TDE Extension Is Now Ready for Production
Andreas 'ads' Scherbaum: Samed YILDIRIM
Ian Barwick: PgPedia Week, 2025-06-29
Housekeeping announcements:
this website's PostgreSQL installation is now on version 17 ( insert champagne emoji here ) the search function now works properly with non-ASCII characters ( there was an embarrassing oversight which went unnoticed until someone kindly pointed it out ) PostgreSQL 18 changes this weekThis week there have been a couple of renamings:
Tomas Vondra: How often is the query plan optimal?
The basic promise of a query optimizer is that it picks the “optimal” query plan. But there’s a catch - the plan selection relies on cost estimates, calculated from selectivity estimates and cost of basic resources (I/O, CPU, …). So the question is, how often do we actually pick the “fastest” plan? And the truth is we actually make mistakes quite often.
Andreas Scherbaum: Performance Test for Percona Transparent Data Encryption (TDE)
Ian Barwick: PgPedia Week, 2025-06-22
PgPedia Week has been delayed this week due to malaise and other personal circumstances.
semab tariq: Choosing the Right Barman Backup Type and Mode for Your PostgreSQL Highly Available Cluster
When running a PostgreSQL database in a High Availability (HA) cluster, it’s easy to assume that having multiple nodes means your data is safe. But HA is not a replacement for backups. If someone accidentally deletes important data or runs a wrong update query, that change will quickly spread to all nodes in the cluster. Without proper safeguards, that data is gone everywhere. In these cases, only a backup can help you restore what was lost.
Dave Stokes: Entity Relationship Maps
Even the most experienced database professionals are known to feel a little anxious when peering into an unfamiliar database. Hopefully, they inspect to see how the data is normalized and how the various tables are combined to answer complex queries. Entity Relationship Maps (ERM) provide a visual overview of how tables are related and can document the structure of the data.
Gabriele Bartolini: CNPG Recipe 20 – Finer Control of Postgres Clusters with Readiness Probes
Explore the new readiness probe introduced in CloudNativePG 1.26, which advances Kubernetes-native lifecycle management for PostgreSQL. Building on the improved probing infrastructure discussed in my previous article, this piece focuses on how readiness probes ensure that only fully synchronised and healthy instances—particularly replicas—are eligible to serve traffic or be promoted to primary.
Seiten
- « erste Seite
- ‹ vorherige Seite
- …
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12