May
09
2025
--

Patroni: The Key PostgreSQL Component for Enterprise High Availability

PostgreSQL high availability with PatroniYou don’t have time for database downtime. Whether you’re managing a high-traffic application, supporting business-critical transactions, or ensuring real-time analytics stay online, the last thing you need is a PostgreSQL failure that grinds everything to a halt. But let’s be real; high availability (HA) in PostgreSQL isn’t something you can just switch on. Setting up […]

Apr
30
2025
--

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 real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in PostgreSQL: PostgreSQL Indexes Can Hurt Performance: Exploring the Negative Effects and the Costs […]

Apr
25
2025
--

pgvector: The Critical PostgreSQL Component for Your Enterprise AI Strategy

pgvector for PostgreSQL enterprise AIYou’re likely racing to enhance your applications with more intelligent, data-driven capabilities, whether through AI-powered models (which have moved into “must implement now!” territory), advanced search functions, real-time fraud detection, or geospatial analysis. As these demands grow, you face a significant challenge: efficiently storing, managing, and querying high-dimensional vector data within your existing database infrastructure. […]

Apr
18
2025
--

Run PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices

Run PostgreSQL on KubernetesRemember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability a constant battle? Thankfully, those days are largely behind us. With better tools, smarter operators, and field-tested strategies, you can now confidently deploy PostgreSQL on Kubernetes, especially when you need scale, automation, and platform consistency. […]

Apr
01
2025
--

Choosing the Right Storage for PostgreSQL on Kubernetes: A Benchmark Analysis

Storage for PostgreSQL on KubernetesAs more organizations move their PostgreSQL databases onto Kubernetes, a common question arises: Which storage solution best handles its demands? Picking the right option is critical, directly impacting performance, reliability, and scalability. For stateful workloads like PostgreSQL, storage must offer high availability and safeguard data integrity, even under intense, high-volume conditions. To address these concerns, […]

Mar
28
2025
--

Transparent Data Encryption for PostgreSQL Release Candidate is Here!

Transparent Data Encryption PostgreSQLPostgreSQL is, without a doubt, one of the most popular open source databases in the world. Why? Well, there are many reasons, but if I had to pick just one, I’d say it’s extensibility. PostgreSQL isn’t just a database; it’s an ecosystem of extensions that can transform it to tackle any upcoming challenges. By enabling […]

Mar
13
2025
--

Using Barman Cloud Utilities for Backups and WAL Archiving in PostgreSQL

Barman Cloud Utilities in PostgreSQLIn this brief blog post, we will talk about Barman cloud utilities, which greatly ease the process of storing backups on cloud platforms like GCP, AWS, Azure, etc. Backups are of paramount importance, and in PostgreSQL, we also need to retain the WAL files, which can be used for various purposes like incremental backups or […]

Mar
12
2025
--

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 blog post explains how HAProxy uses Health check endpoints with Patroni and how to debug the status issue. HAProxy and Patroni setup: Sample configuration: [crayon-67dc5ad8bfe99748452184/]   [crayon-67dc5ad8bfea5138973971/]   OPTIONS /primary: This is the primary health […]

Feb
07
2025
--

Encrypt PostgreSQL Data at Rest on Kubernetes

Encrypt PostgreSQL Data at Rest on KubernetesThe upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. Since pg_tde comes pre-installed in Percona’s official PostgreSQL 17 images, this release presents an excellent opportunity to implement Transparent Data Encryption in your Kubernetes-deployed databases. Let’s look at how to configure and use pg_tde with […]

Jan
14
2025
--

What Hurts in PostgreSQL Part One: Temporary Tables

Temporary Tables PostgreSQLPostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great power, especially its modern SQL language features. However, that doesn’t mean everything is great. There are areas where it hurts. Novice users unaware of the problem might get into trouble, and I see such things […]

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com