by Jorge Torralba | Jul 11, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. If you’re a DBA who’s comfortable with Oracle, MySQL, or SQL Server, stepping into PostgreSQL can...
by David Quilty | Jul 10, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
Do you find yourself struggling with geospatial data in your database? You know the feeling: you need quick answers about locations, distances, and relationships between points on a map, but your database just wasn’t built for these questions. The problem? While...
by Robert Bernier | Jul 8, 2025 | Insight for DBAs, Percona Software, PostgreSQL, Security
Welcome to the open source implementation of PostgreSQL Transparent Data Encryption! This question was posed on the PostgreSQL forum, and the good news is that it’s actually pretty easy to do! Q: Is it possible to automate the steps to enable pg_tde for all new...
by Agustín | Jul 5, 2025 | PostgreSQL, Security
This post was originally published in July 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. Protecting data in transit is just as important as protecting it at rest. If connections to...
by Pep Pla | Jul 3, 2025 | Insight for DBAs, MySQL, PostgreSQL
Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. This post is about how to handle torn pages. As a long-time open source database administrator, I have always been...
by Fernando Laudares Camargos | Jul 2, 2025 | Benchmarks, PostgreSQL, ProxySQL
In the first post of this series (Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To), I presented my test environment and methodology and explained how to install ReadySet, ProxySQL, and HAproxy and configure them to work...
by Fernando Laudares Camargos | Jul 1, 2025 | Benchmarks, PostgreSQL, ProxySQL
A couple of weeks ago, I attended a PGDay event in Blumenau, a city not far away from where I live in Brazil. Opening the day were former Percona colleagues Marcelo Altmann and Wagner Bianchi, showcasing ReadySet’s support for PostgreSQL. Readyset is a...
by Sergey Pronin | Jul 1, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2021 and was updated in 2025. Kubernetes adoption keeps climbing, and databases are often one of the last workloads teams try to move. The reasons are clear: PostgreSQL is critical, downtime isn’t an option, and migration can feel...
by Jan Wieremjewicz | Jun 30, 2025 | Open Source, PostgreSQL
Lately, it feels like every time I go to a technical conference, someone is talking about how great PostgreSQL is. I’d think it’s just me noticing, but the rankings and surveys say otherwise. PostgreSQL is simply very popular. From old-school bare metal setups to VMs,...
by Sergey Pronin | Jun 29, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2023 and was updated in 2025. PostgreSQL is a natural fit for modern cloud-native environments, but running it on Kubernetes can be more complicated than it looks. From provisioning to backups, there’s a lot to get right before...
by Edith Puclla | Jun 27, 2025 | Open Source, Percona Services, PostgreSQL
by Mario García | Jun 24, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in March 2023 and was updated in June 2025. If you’re using PostgreSQL in the cloud, there’s a good chance you’re spending more than you need in order to get the results required for your business. Effectively managing PostgreSQL...
by Anup Gupta | Jun 16, 2025 | Insight for DBAs, PostgreSQL
Repmgr is an open source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL’s built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks...
by David Stokes | Jun 16, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored in 2022. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. PostgreSQL 15 introduced the MERGE command, a feature that has a big impact on how you can manage data...
by Sergey Pronin | Jun 11, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. Running PostgreSQL on Kubernetes promises flexibility, but storage decisions can quickly make or...
by David Quilty | Jun 10, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored in 2024 and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring the original perspective. PostgreSQL is known for its reliability and feature-rich environment, but as with any database, when...
by Anup Gupta | Jun 9, 2025 | Insight for DBAs, PostgreSQL
Patroni is a Python-based template for managing high availability PostgreSQL clusters. Originally a fork of the Governor project by Compose, Patroni has evolved significantly with many new features and active community development. It supports integration with various...
by David Quilty | Jun 6, 2025 | Insight for DBAs, Percona Software, PostgreSQL
If your database is getting slower, your users don’t care why. They just want it to work. Meanwhile, you’re stuck dealing with the symptoms: sluggish apps, spiking resource usage, and support tickets piling up faster than your monitoring alerts can handle....
by Robert Bernier | Jun 4, 2025 | Monitoring, PostgreSQL, Security
This post was originally written in 2020 and was updated in 2025. PostgreSQL security done right protects data, improves performance, keeps systems stable, and supports a healthier development cycle. Because PostgreSQL security can sprawl, this post focuses on the...
by Avinash Vallarapu | Jun 1, 2025 | Insight for DBAs, PostgreSQL
This blog was originally written in September 2018 and was updated in March 2025. In this post, we cover the methods used to achieve an enterprise-grade PostgreSQL backup strategy. We’ll explore options like pg_basebackup and WAL archiving to enable PostgreSQL...
