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...
by David Stokes | Mar 28, 2024 | Open Source, Percona Software, PostgreSQL
Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. Progress is ongoing, and Percona would love your feedback, so please download and test. Documentation The pg_tde...
by Kai Wagner | Mar 27, 2024 | Monitoring, Percona Software, PostgreSQL
Database monitoring tools play a crucial role in ensuring the smooth operation and performance optimization of database systems, and Percona Monitoring and Management (PMM) has been a go-to choice for many organizations seeking robust monitoring solutions for their...
by Shivam Dhapatkar | Mar 22, 2024 | Insight for DBAs, PostgreSQL
PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. The following are the primary configuration files of the PostgreSQL database: postgresql.conf:...
by Abhishek Deb | Mar 21, 2024 | Insight for DBAs, PostgreSQL
PostgreSQL has a feature called data checksum which is used to detect any storage-level corruption of data pages. However, a new PostgreSQL database cluster does not have this feature enabled by default. To activate this feature, you must specify the...
by Daniel Guzmán Burgos | Mar 20, 2024 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
When checking for how good (or bad) a PostgreSQL instance is behaving, one just wants to see everything that matters on a single-ish page. That’s what the new summary dashboard in Percona Monitoring and Management (PMM) is achieving: So, what is “everything that...
by David Gonzalez | Mar 20, 2024 | Insight for DBAs, PostgreSQL
In a previous blog, One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only, we reviewed three ways PostgreSQL can use an index to retrieve data as quickly as possible. In the same blog, we saw the fastest and most efficient method is the...
by Robert Bernier | Mar 12, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL extensions are great! Simply by adding an extension, one transforms what is an otherwise vanilla general-purpose database management system into one capable of processing data requirements in a highly optimized fashion. Some extensions, like pg_repack,...
by Sergey Pronin | Mar 4, 2024 | Cloud, Percona Software, PostgreSQL
Percona Operator for PostgreSQL is now Red Hat OpenShift certified. You can now use Percona Operator for PostgreSQL to deploy and manage highly available PostgreSQL clusters on OpenShift. Certification guarantees that our Operator meets standards for interoperability,...
by Agustín | Feb 13, 2024 | Insight for DBAs, PostgreSQL
In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or relations- in PostgreSQL. Alignment In its internal representation of tuples, Postgres will set each column at a position depending on the alignment...
by Sonia Valeja | Feb 7, 2024 | Insight for DBAs, PostgreSQL
Backup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration often combines backup and expiry together. At times, due to slow network bandwidth, huge database sizes, or any...
by Ibrar Ahmed | Feb 2, 2024 | Insight for DBAs, PostgreSQL, Security
This blog was originally published in December of 2022 and updated in February of 2024. Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is often done to protect...
by Ninad Shah | Feb 2, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and was updated in February of 2024. On occasion, DBAs come across segmentation fault issues while executing some queries. However, this is one of the least-explored topics to date. I tried to search for details...
by David Stokes | Feb 1, 2024 | Database Trends, Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and updated in February of 2024. For more than a quarter of a century, people have been discussing “Which is better, MySQL vs PostgreSQL?” — with no resolution. When people ask me which is better, I have to ask them...
by David Stokes | Jan 30, 2024 | Open Source, Percona Software, PostgreSQL
PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that I reviewed last October. There have been a lot of changes that covered in this post. This software is under active development. In the spirit of open and transparent...
by David Quilty | Jan 30, 2024 | Insight for DBAs, PostgreSQL
Are you planning to upgrade your PostgreSQL database but feeling overwhelmed by the complexity of the task? We have something that will make your life much easier. Introducing The Ultimate PostgreSQL Upgrade Checklist – designed to guide both seasoned and new DBAs...
by David Stokes | Jan 29, 2024 | Open Source, Percona Software, PostgreSQL
PostgreSQL differs from certain other databases as it lacks a native solution to encrypt data on disk transparently. At Percona, we are in the process of developing PG_TDE, a tool designed to encrypt data using the AES-CTR encryption algorithm. This code is currently...
by David Stokes | Jan 26, 2024 | Open Source, Percona Software, PostgreSQL
Securing your data can be a tough task. Unlike some other databases, PostgreSQL does not have a native solution to encrypt data on disk transparently. Percona is developing PG_TDE to encrypt that data using the AES-CTR encryption algorithm. This code is in...
