by Jan Wieremjewicz | Sep 19, 2023 | Insight for DBAs, Percona Software, PostgreSQL
PostgreSQL Community released PostgreSQL 16 on September 14, 2023. In years past, we’ve released our Distribution for PostgreSQL a few months later. We wanted to improve in this regard and establish a new release baseline. Improving quality while maintaining...
by David Stokes | Sep 1, 2023 | Insight for DBAs, MySQL, PostgreSQL
MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. The good news is that for someone familiar with MySQL, they have the basics of databases covered and can explore some of the treasures to be discovered in the new...
by Jobin Augustine | Aug 30, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
This blog was published in August 2023 and updated in April 2024. PostgreSQL allows its users to set parameters at different scopes, and the same parameter can be specified at different places and using different methods. And there could be conflicts. Someone might be...
by Robert Bernier | Aug 29, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
Over the years, I’ve had the opportunity to architect all sorts of configurations using Postgres as a backend. I’ve always found it very cool and satisfying to implement sophisticated business rules, often in more ways than one has fingers and toes. So, it’s not an...
by Robert Bernier | Aug 21, 2023 | Insight for DBAs, PostgreSQL
Effectively working with LDAP as an authentication mechanism for PostgreSQL typically requires extensive knowledge in both domains. While trying to be as complete yet succinct as possible, I’m detailing how to enable TLS between a PostgreSQL and the OpenLDAP server....
by Sonia Valeja | Aug 16, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical...
by Jobin Augustine | Jul 20, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
It is very common to see many infrastructure layers standing between a PostgreSQL database and the Application server. The most common ones are connection poolers, load balancers, routers, firewalls, etc. We often forget or take for granted the network hops involved...
by Sergey Pronin | Jul 19, 2023 | Cloud, Percona Software, PostgreSQL
In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications...
by Mateusz Henicz | Jul 7, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
Changing the data type on a column in a big table is almost always a pain. It can lock out the entire table for reading and writing because of the exclusive lock acquired by the ALTER TABLE statement that changes the data type. In this blog post, we will look at one...
by David Gonzalez | Jul 6, 2023 | Insight for DBAs, PostgreSQL
Performance is one of the essential aspects of a database management system. Very little can be more annoying and frustrating for users than poor performance, meaning long-running queries and high response times at the front end. One of the most effective ways to...
by Sergey Pronin | Jun 30, 2023 | Cloud, Percona Software, PostgreSQL
Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. The solution is 100% open source and automates the deployment and management of PostgreSQL clusters on...
by Sagar Jadhav | Jun 29, 2023 | Insight for DBAs, PostgreSQL
The PostgreSQL Write-Ahead Log (WAL) is a recording location within the Postgres cluster, capturing all modifications made to the cluster’s data files before being written to the heap. During crash recovery, the WAL contains sufficient data for Postgres to...
by Abhishek Deb | Jun 26, 2023 | Insight for DBAs, PostgreSQL
We have faced different levels of corruption related to databases in PostgreSQL. Our colleague has written multiple blogs on the subject; please refer to the below links for more: The Ultimate Guide to Database Corruption: Part 1 – An Overview The Ultimate Guide to...
by Robert Bernier | Jun 15, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply as GIS, can be considered in some ways as a rite of passage. The complexities and challenges involved in learning, which are...
by Peter Zaitsev | Jun 14, 2023 | Insight for DBAs, PostgreSQL
A few days ago, Heikki Linnakangas posted a message in the PostgreSQL mailing list titled “Let’s make PostgreSQL multi-threaded.” This topic got quite a discussion on Hacker News too. The poll I’ve done on Twitter shows there is great interest in this topic and...
by Pete Scott | Jun 12, 2023 | Insight for DBAs, MySQL, Percona Software, PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied....
by Agustín | Jun 9, 2023 | Insight for DBAs, Monitoring, PostgreSQL
Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters. In this short blog post, we will see how to quickly (and...
by Sonia Valeja | Jun 7, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database...
by Robert Bernier | Jun 5, 2023 | Insight for DBAs, PostgreSQL
From time to time, situations occur where unusual circumstances dictate out-of-the-box thinking. For example, suppose you have a system where you’ve installed multiple data clusters onto a single host. What you end up with is a host breaking up and sharing valuable...
by Bhargav Kamineni | May 8, 2023 | Insight for DBAs, PostgreSQL
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating...
