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 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 Anil Joshi | Jan 2, 2025 | Insight for DBAs, PostgreSQL
As we know, Patroni is a well-established standard for an HA framework for PostgreSQL clusters. From time to time, we need to perform maintenance tasks like upgrading the topology or making changes to the existing setup. Here, we will discuss mainly how we can replace...
by Jorge Torralba | Aug 5, 2022 | Insight for DBAs, PostgreSQL
I have been working with Postgres now for many years, most recently as a consultant at Percona for companies with new implementations of Postgres as a result of migrating from Oracle or some other legacy database engine. In some cases, these are Fortune 100 companies...
by Daniil Bazhenov | Nov 9, 2020 | Insight for DBAs, MySQL, Open Source, PostgreSQL
Percona University Online has released its second free course, “A Deep Dive Into PostgreSQL Indexes” by Ibrar Ahmed, Senior Software Engineer at Percona. Indexes are a basic feature of relational databases. PostgreSQL offers a rich collection of index...
by Robert Bernier | Jan 21, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of 2019 but things have been so busy that this is the first chance I’ve had to write. For my first blog, I’d like to write about … you. Or,...
by Dave Avery | Mar 7, 2018 | Percona Live, PostgreSQL, Security
Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post...
by Nickolay Ihalainen | Feb 9, 2018 | Monitoring, Percona Software, PostgreSQL
In this article, we’ll describe how to collect PostgreSQL metrics with Percona Monitoring and Management (PMM). We designed Percona Monitoring and Management (PMM) to be the best tool for MySQL and MongoDB performance investigation. At the same time, it’s...
by Manjot Singh | Sep 7, 2017 | MySQL
In this blog post, I’ll look at a comparison of PostgreSQL and MySQL. I came across a post from Hans-Juergen Schoenig, a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better. While his post ignores most of the reasons why...
by Dave Avery | Jun 13, 2017 | Insight for DBAs, MySQL, PostgreSQL, Webinars
Join Percona’s Senior Technical Services Engineer Emanuel Calvo as he presents Demystifying Postgres Logical Replication on Thursday, June 15, 2017 at 7 am PDT / 10 am EDT (UTC-7). Register Now The Postgres logical decoding feature was added in version 9.4, and...
by Dave Avery | Apr 25, 2017 | Cloud, MySQL, Percona Live, PostgreSQL
The Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres. If you’re...
