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:...
by Neha Korukula | Apr 3, 2024 | Insight for DBAs, PostgreSQL
A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database. PostgreSQL implements portions of the SQL/MED specification,...
by David Stokes | Apr 2, 2024 | Insight for DBAs, PostgreSQL
Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified...
by Pablo Svampa | Apr 2, 2024 | Insight for DBAs, PostgreSQL
One of the most frequent concerns we see in the Percona support team is: Why is my pg_wal growing? / pg_wal is filling up the filesystem / pg_wal does not release the space, and so on. In PostgreSQL, the pg_wal directory plays a crucial role in managing the...
by David Stokes | Apr 1, 2024 | Percona Software, PostgreSQL, Security
Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. We are actively asking you to test this code to help build a better project. So please test pg_tde! As you have probably read in earlier blogs on pg_tde, it depends on a...
by Jobin Augustine | Apr 1, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
This blog was originally published in April 2023 and was updated in April 2024. Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep...
by Neha Korukula | Apr 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in July 2023 and was updated in April 2024. Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. In this article, we’ll discuss how to effectively use traditional...
by Kai Wagner | Apr 1, 2024 | Percona Software, PostgreSQL
This blog was published in April of 2023 and updated in April 2024. PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability,...
by Jobin Augustine | Apr 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in June 2022 and was updated in April 2024. PostgreSQL’s built-in autovacuum – the housekeeper – is improving, version after version. It is becoming more capable while reducing its overhead and addressing edge cases. I think there is...
