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 Ibrar Ahmed | Jan 2, 2024 | Insight for DBAs, PostgreSQL, Security
This blog was published in January of 2021 and was updated in January of 2024.Database security, particularly in the context of PostgreSQL, involves safeguarding multiple parts of the database ecosystem. It is a vast topic because, with databases, we need to secure... by Ibrar Ahmed | Jun 1, 2023 | Insight for DBAs, PostgreSQL
This blog post was originally published in January 2023 and was updated in June 2023.In PostgreSQL, the vacuum command is a maintenance task that helps to optimize database performance and reclaim disk space. Using the PostgreSQL vacuum command involves removing... by Ibrar Ahmed | May 1, 2023 | Insight for DBAs, Open Source, PostgreSQL
This blog was originally published in August 2018 and was updated in May 2023.Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Default values are set to ensure that PostgreSQL runs everywhere, with the least resources it... by Ibrar Ahmed | Feb 2, 2023 | Featured, Insight for DBAs, PostgreSQL, Security
Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. The authentication process is typically accomplished through... by Ibrar Ahmed | Feb 1, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to... by Ibrar Ahmed | Jan 11, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL is a powerful and flexible open-source database management system that allows users to install and use extensions to add additional functionality to their databases. In this tutorial, we will cover the process of installing and upgrading PostgreSQL... by Ibrar Ahmed | Nov 29, 2021 | Insight for DBAs, PostgreSQL
PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a monitoring perspective. As we know, monitoring is the key element of any database management system, and PostgreSQL... by Ibrar Ahmed | Aug 23, 2021 | Insight for DBAs, PostgreSQL, Security
Security is everybody’s concern when talking about data and information, and therefore it becomes the main foundation of every database. Security means protecting your data from unauthorized access. That means only authorized users can log in to a system called... by Ibrar Ahmed | Jul 30, 2021 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well.PostgreSQL provides very detailed... by Ibrar Ahmed | Jun 2, 2021 | Insight for DBAs, PostgreSQL
Note: PostgreSQL 14 has been released. Please visit PostgreSQL 14 – Performance, Security, Usability, and Observability for additional information. It’s exciting times in the PostgreSQL world with the version 14 beta released a few days ago.... by Ibrar Ahmed | May 27, 2021 | Insight for DBAs, PostgreSQL
On September 30, 2021, PostgreSQL 14 was released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability.Foreign Data Wrapper based on SQL-MED is one the coolest features of... by Ibrar Ahmed | Feb 1, 2021 | Insight for DBAs, PostgreSQL, Security
Recently, I wrote an overview about what you need to know about PostgreSQL security. For this post, I want to write about PostgreSQL authentication. It is divided into three categories: 1. PostgreSQL Internal Authentication, 2. OS-based Authentication, and 3. External... by Ibrar Ahmed | Jan 28, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Some time ago, I required a specific version of PostgreSQL. After searching on all the repositories, I was unable to find that specific version. It seems that the PostgreSQL community removes the old package when a new minor version comes. For example, if you need the... by Ibrar Ahmed | Oct 1, 2020 | Insight for DBAs, Open Source, PostgreSQL
There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb... by Ibrar Ahmed | Sep 30, 2020 | PostgreSQL, Security
PostgreSQL 13 is released with some cool features, such as index enhancement, partition enhancements, and many others. Along with these enhancements, there are some security-related enhancements that require some explanation. There are two major ones: one is related... by Ibrar Ahmed | Sep 10, 2020 | Insight for DBAs, PostgreSQL
Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash, GIN, GIST, and BRIN indexes. And because the... by Ibrar Ahmed | Jul 28, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
The PostgreSQL 13 Beta is out in the testing phase with a rich feature set. It is a very good learning effort to participate in the testing of one of the finest databases in the world. It does not matter how much development, coding, and administration experience you... by Ibrar Ahmed | Jun 9, 2020 | Insight for DBAs, PostgreSQL
Due to the immense generation of data, scalability has become one of the hottest topics in the field of databases. Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the... by Ibrar Ahmed | Jun 5, 2020 | Insight for DBAs, PostgreSQL
Sometimes PostgreSQL users get errors and warnings and they are unable to understand why. To cater to these situations, this blog will cover some common errors and warnings in PostgreSQL. In some cases, it is a user setting problem or query error, but in other cases,...