PostgreSQL Archives (original) (raw)
Benchmarking PostgreSQL: The Hidden Cost of Over-Indexing
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause [...]
pgvector: The Critical PostgreSQL Component for Your Enterprise AI Strategy
You’re likely racing to enhance your applications with more intelligent, data-driven capabilities, whether through AI-powered models (which have moved into [...]
Run PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices
Remember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability [...]
Common PostgreSQL Upgrade Errors and How to Avoid Them
This post was originally published in January 2024 and was updated in April 2025. Everyone usually welcomes an upgrade, whether [...]
Choosing the Right Storage for PostgreSQL on Kubernetes: A Benchmark Analysis
As more organizations move their PostgreSQL databases onto Kubernetes, a common question arises: Which storage solution best handles its demands? [...]
Transparent Data Encryption for PostgreSQL Release Candidate is Here!
PostgreSQL is, without a doubt, one of the most popular open source databases in the world. Why? Well, there are [...]
Reducing PostgreSQL Costs in the Cloud
This post was originally published in March 2023 and was updated in March 2025. If you’re using PostgreSQL in the [...]
Using Barman Cloud Utilities for Backups and WAL Archiving in PostgreSQL
In this brief blog post, we will talk about Barman cloud utilities, which greatly ease the process of storing backups [...]
HAProxy-Patroni Setup Using Health Check Endpoints and Debugging
Patroni has a REST API that allows HAProxy and other kinds of load balancers to perform HTTP health checks. This [...]
This post was originally published in June 2020 and was updated in March 2025. PostgreSQL users sometimes encounter errors and [...]
PostgreSQL Backup Strategies for Enterprise-Grade Environments
This blog was originally written in September 2018 and was updated in March 2025. In this post, we cover the [...]
How to Upgrade PostgreSQL Extensions: A Simple Guide
This post was originally written in January 2023 and was updated in February 2025. PostgreSQL is a powerful and flexible [...]
Encrypt PostgreSQL Data at Rest on Kubernetes
The upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. [...]
What is PostgreSQL? Everything You Need to Know
This blog was originally published in February of 2023 and updated in February 2025. What is PostgreSQL? It’s a powerful, [...]
What Hurts in PostgreSQL Part One: Temporary Tables
PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great [...]
PostgreSQL vs. the Cloud for GenAI? 4 Things to Consider
Originally published on The New Stack. Cloud-related regulatory, security and financial issues prompt many to weigh the benefits of building GenAI [...]
Your Data’s Not Safe Until It’s TDE-Safe — Here’s How
If you’re managing a PostgreSQL database and handling sensitive data or PII, the answer is simple: You need data-at-rest encryption. [...]
How to Replace Patroni and Etcd IP/Host Information in PostgreSQL
As we know, Patroni is a well-established standard for an HA framework for PostgreSQL clusters. From time to time, we [...]
Performing ELT Operations Using DOMAINs
First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into [...]
Using Loki and Promtail to Display PostgreSQL Logs From a Kubernetes Cluster in PMM
This is a follow-up to my colleagues Nickolay and Phong’s Store and Manage Logs of Percona Operator Pods with PMM [...]