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...
by Ninad Shah | Jan 25, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
In every database product, sequential scans or full table scans are often resource consuming, so almost all the developers and DBAs see such scans as a performance killer. In my opinion, this is a false perception or biased view. In many cases, sequential scans are...
by Sergey Pronin | Jan 9, 2024 | Open Source, PostgreSQL
2023 was the year of Artificial Intelligence (AI). A lot of companies are thinking about how they can improve user experience with AI, and the most usual first step is to use company data (internal docs, ticketing systems, etc.) to answer customer questions faster and...
by Jobin Augustine | Dec 29, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL 14 introduced the parameter idle_session_timeout, and, unfortunately, many DBAs jumped to start using it without understanding or by ignoring the consequences. In a short span of time, it has become one of the most misused parameters in many PostgreSQL...
by Robert Bernier | Dec 26, 2023 | Insight for DBAs, Percona Software, PostgreSQL
This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard. About the environment Grafana: version 10.0.0 Grafana database backend: Prometheus...
by Nickolay Ihalainen | Dec 20, 2023 | Cloud, Percona Software, PostgreSQL
Huge pages make PostgreSQL faster; can we implement it in Kubernetes? Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make...
by Zsolt Parragi | Dec 19, 2023 | Percona Software, PostgreSQL
PG_TDE (PostgreSQL Transparent Data Encryption) is an experimental transparent data encryption access method for PostgreSQL 16, available on GitHub as an extension for vanilla PostgreSQL. Since our previous blog post, Adding Transparent Data Encryption to PostgreSQL...
by Abhishek Deb | Dec 15, 2023 | Insight for DBAs, PostgreSQL
A database role can have a number of attributes that define its privileges and interact with the client authentication system.One such attribute is the CREATEROLE attribute, which is important to PostgreSQL database management of users and roles. In this blog post, we...
by Bhargav Kamineni | Dec 14, 2023 | Insight for DBAs, PostgreSQL
While a hallmark feature of PostgreSQL is streaming replication, sometimes data demands a more refined and adaptable replication approach to address different requirements. Logical replication offers a distinct advantage over traditional streaming replication by...
by Sagar Jadhav | Dec 5, 2023 | Insight for DBAs, PostgreSQL
Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot, exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. It was a fascinating read,...
by Neha Korukula | Dec 1, 2023 | Insight for DBAs, PostgreSQL
The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community. pg_partman is an extension that streamlines the creation and management of table partition sets, supporting both time-based...
