by David Stokes | Jul 28, 2022 | Insight for DBAs, MySQL, PostgreSQL
Episode 8 in the PostgreSQL for MySQL DBAs series covers materialized views. MySQL has had views for many years and they are very useful, but it has never had materialized views. Those who use materialized views appreciate their utility and here we will cover how they...
by David Stokes | Jul 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Experienced MySQL DBAs exploring PostgreSQL are often shocked to learn that they will need to vacuum their tables. This is not using a Hoover brand-like device or letting a Roomba-like robot loose on the server. Vacuuming is a necessary part of maintenance on a...
by David Stokes | Jul 15, 2022 | Insight for DBAs, MySQL, PostgreSQL
The differences between MySQL and PostgreSQL are often trivial but occasionally there are stark differences. A MySQL DBA wanting to optimize a query on a PostgreSQL server will hopefully have some experience with using EXPLAIN. For the uninitiated, the keyword...
by David Gonzalez | Jul 14, 2022 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Consuming data from a remote foreign database into our local database just like another local table is a great feature that adds an excellent level of flexibility to the design of a database solution. This option is present in a number of database products. Oracle...
by Robert Bernier | Jul 13, 2022 | Insight for DBAs, PostgreSQL
Well, it’s that time of the year when once again we have a look at the newest version of PostgreSQL. As tradition dictates, here at Percona, the team is given a list of features to write about. Mine happened to be about a very basic and, I might add, important...
by Hamid Akthar | Jul 7, 2022 | Insight for DBAs, PostgreSQL
Replication sits at the core of database high availability (HA). While on-disk data can be replicated through various methods, whether hardware or software, disk, file, or block-based solutions, without an online copy of the database, HA setup cannot be achieved. This...
by David Stokes | Jun 30, 2022 | Insight for DBAs, MySQL, PostgreSQL
Many MySQL DBAs have expressed interest in learning about PostgreSQL and this series is a guided tour through the basics. One of the ‘Wow! That is Different!’ things for MySQL DBAs looking at PostgreSQL are sequences. Sequences can be used as a rough...
by David Stokes | Jun 21, 2022 | Insight for DBAs, MySQL, PostgreSQL
The videos for PostgreSQL for MySQL Database Administrators (DBA) episodes three and four are live here and here. Episode three covers a simple backup and restoration while episode four covers some handy PSL commands. For those of you who missed the first two videos...
by David Stokes | May 24, 2022 | Database Trends, Insight for DBAs, PostgreSQL
PostgreSQL 15 Beta 1 was announced on May 15th and to keep with the spirit of past peeks at MySQL and MariaDB products, this is a cursory glance at the release notes to see what is coming. This is a preview of all the features that will be in the General Available...
by Matt Yonkovit | May 5, 2022 | Percona Software, PostgreSQL
Awesome news, pg_stat_monitor has reached a GA STATUS! Percona has long been associated with pushing the limits and understanding the nuances involved in running database systems at scale, so building a tool that helps get us there brings a bit more insight and...
by Robert Bernier | Apr 27, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
It’s a funny thing when the topic of database sizes comes up. Calling one small, medium, large, or even huge isn’t as straightforward as you’d think. Distinguishing the size of a database is based upon a number of factors whose characteristics can be...
by Hamid Akthar | Apr 19, 2022 | Insight for DBAs, PostgreSQL
Concurrent access to data within PostgreSQL is managed with the Multiversion Concurrency Control (MVCC) model. Data snapshots are maintained for each SQL statement so that they always get consistent data, even if other transactions are modifying it concurrently. This...
by Dmitriy Kostiuk | Apr 13, 2022 | Cloud, Percona Software, PostgreSQL
Tablespaces allow DBAs to store a database on multiple file systems within the same server and to control where (on which file systems) specific parts of the database are stored. You can think about it as if you were giving names to your disk mounts and then using...
by Robert Bernier | Apr 13, 2022 | Insight for DBAs, Open Source, PostgreSQL
Transaction ID Wraparound occurs when the VACUUM process cannot keep up with database activity and the PostgreSQL service is forced to shut down. In more technical parlance: Transaction ID Wraparound occurs when the semantics of Multi-Version Concurrency Control...
by Mike Benshoof | Mar 24, 2022 | Insight for DBAs, MySQL, PostgreSQL
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the end of time, it will always be “the best”. In some cases, the debate is actually based on matching the use case to the proper tech (I’m looking at you SQL vs...
by Sergey Pronin | Mar 15, 2022 | Cloud, Open Source, Percona Software, PostgreSQL
Avoid vendor lock-in, provide a private Database-as-a-Service for internal teams, quickly deploy-test-destroy databases with CI/CD pipeline – these are some of the most common use cases for running databases on Kubernetes with operators. Percona Operator for...
by Jobin Augustine | Feb 25, 2022 | Insight for DBAs, PostgreSQL
I recently blogged about how Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster. In fact, nothing else was hurting a logical replication as much as this problem. Even while I am writing this post, I could see customers/users...
by David Gonzalez | Feb 8, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
The PostgreSQL RDBMS has shown rapid growth in terms of adoption and usability for a wide range of industries and projects. The same is true as for the new methodologies for application development and deployment, which currently focuses on making it easier for...
by Robert Bernier | Jan 31, 2022 | Database Trends, Insight for DBAs, Insight for Developers, PostgreSQL
Note: In the original version of this post, there were some issues missed. These have been addressed at the bottom of the post. I’d like to introduce to you a very cool feature introduced in PostgreSQL, the Pipeline Mode. So just what exactly is Pipeline Mode?...
by Jobin Augustine | Jan 25, 2022 | Insight for DBAs, PostgreSQL, Security
Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. “Why do I get the error FATAL: password authentication failed for a user in the new server?” has become one of the most intriguing questions. At...
