by Sergey Pronin | Jul 8, 2024 | Cloud, Percona Software, PostgreSQL
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...
by Bhargav Kamineni | Jul 3, 2024 | Insight for DBAs, PostgreSQL
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...
by Neha Korukula | Jul 2, 2024 | Insight for DBAs, PostgreSQL
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...
by Abhishek Deb | Jul 1, 2024 | Insight for DBAs, PostgreSQL
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...
by Sonia Valeja | Jun 25, 2024 | Insight for DBAs, PostgreSQL
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...
by Jobin Augustine | Jun 24, 2024 | Insight for DBAs, PostgreSQL
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...
by Sveta Smirnova | Jun 12, 2024 | MongoDB, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and...
by Robert Bernier | Jun 5, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
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:...
by Jobin Augustine | Jun 3, 2024 | Insight for DBAs, PostgreSQL
Multi-tenancy/co-hosting is always challenging. Running multiple PG instances could help to reduce the internal contention points (scalability issues) within PostgreSQL. However, the load caused by one of the tenants could affect other tenets, which is generally...
by Smit Arora | Jun 1, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in September 2023 and was updated in June 2024. In simple terms, a join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. Some of...
by David Stokes | May 30, 2024 | Insight for DBAs, PostgreSQL
PostgreSQL releases are incremental evolutions that improve the product. The beta version 17 was recently released, and there are two small items you may overlook unless you have them pointed out to you. So, “Point! Point!” MERGE() MERGE() was a new feature of...
by Sergey Pronin | May 8, 2024 | Cloud, Percona Software, PostgreSQL
Coroot, an open source observability tool powered by eBPF, went generally available with version 1.0 last week. As this tool is cloud-native, we were curious to know how it can help troubleshoot databases on Kubernetes. In this blog post, we will see how to quickly...
by Pablo Svampa | May 7, 2024 | Insight for DBAs, PostgreSQL
Last week, we were assisting a client who needed to resolve an issue related to partitioned tables. Often, a table can include dozens or even hundreds of partitions. Unfortunately, some object-level parameters for tuning (like storage_parameter) cannot be modified...
by Jobin Augustine | Apr 30, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL, Security
There are many cases where external connection poolers like pgBouncer become unavoidable despite the costs and complexities associated with them. PgBouncer is one of the most popular external connection poolers for PostgreSQL. It is thin and lightweight, so it...
by Zsolt Parragi | Apr 26, 2024 | Percona Software, PostgreSQL
The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared to our previous MVP release. In addition to lots of bug fixes, the new release supports multi-tenancy and key rotation with a simplified...
by David Quilty | Apr 18, 2024 | Insight for DBAs, MongoDB, MySQL, PostgreSQL
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of experience as a DBA or whether you manage databases for a small or large...
by Edith Puclla | Apr 17, 2024 | Insight for Developers, PostgreSQL
This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch...
by Ninad Shah | Apr 12, 2024 | Insight for DBAs, MySQL, PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this...
by David Stokes | Apr 11, 2024 | Insight for DBAs, PostgreSQL
by Kai Wagner | Apr 9, 2024 | Open Source, Percona Software, PostgreSQL, Security
Disclaimer: This blog post is no longer up-to-date. The pg_tde extension has since been released as production-ready. For the latest information, please refer to the official announcement or documentation below:...
