Running a high-performance, reliable PostgreSQL database is crucial for any business and application. However, as workloads grow and database environments become more complex, ensuring optimal database performance can be difficult. This is where PostgreSQL monitoring comes into play.  Monitoring PostgreSQL databases is useful for proactively detecting and resolving performance bottlenecks before they affect applications and ..read more

The PostgreSQL Global Development team released the second beta version of PostgreSQL 17 on June 27th, 2024, and it is now available for testing. In this beta version, we can explore the new features that will be released in the official final release of PostgreSQL 17. In this blog, we will discuss some of the ..read more

PostgreSQL major versions are released every year, with each release delivering better performance and new features. With such rapid innovation, it is inevitable that there will be a need to upgrade from one version to another. Upgrade procedures are usually very complex and require thorough planning. With the 2.4.0 release of Percona Operator for PostgreSQL ..read more

In one of our previous blogs, a custom method for switching from PostgreSQL physical replication to logical replication was discussed, using pg_create_logical_replication_slot and pg_replication_slot_advance. PostgreSQL 17, set to be released this year, introduces the pg_createsubscriber utility, simplifying the conversion from physical to logical replication. This post will cover using pg_createsubscriber to convert physical to logical ..read more

In this blog, we will see the concepts for analyzing WAL files, such as pg_waldump (supported versions 12 and above) and pg_walinspect (supported versions 15 and above). Write-Ahead Logging (WAL) is a standard approach to transaction logging and one of the database’s functional components. WAL is a standard method for ensuring data durability. It records ..read more

In PostgreSQL, an “orphan large object” refers to a large object (LOB) that exists in the pg_largeobject system table but is not associated with any specific row in a user-defined table. This situation can occur due to various reasons, such as when the large object was created, but its reference in the user table was ..read more

PostgreSQL is a powerful and versatile relational database management system that provides many features for managing and manipulating databases. One such feature is the is_template flag, which can be used to create and manage template databases. In this blog post, we will explore what the is_template flag is, why it is useful, and how to ..read more

We have been promoting and using Patroni as the best high availability framework for PostgreSQL, and Etcd was the preferred/recommended DCS for the Patroni cluster. Both Patroni and Etcd have been part of PostgreSQL distribution from Percona for years now. But one area where we were stuck was the Etcd version, and we continued to ..read more

PostgreSQL is known for its reliability and feature-rich environment, but as with any database, when datasets grow larger and query complexity increases, efficient data retrieval becomes crucial for maintaining optimal database performance. This is where indexes play a vital role, enhancing performance by allowing for faster data retrieval.Indexes are data structures that store a subset ..read more

There are quite a number of methods these days for installing Patroni. I want to discuss the next step, which is how to start tuning a running system.The manner of updating a running Postgres server typically involves editing the standard Postgres files: postgresql.conf postgresql.auto.conf pg_hba.conf Working with a Patroni HA cluster, one has the added ..read more