DBA
How to use a Binary Search Key
Understanding how Binary Search Key works? A binary search key is used to quickly search for a specific value in a sorted array or list. The basic idea behind the binary search algorithm is to […]
Articles by MinervaDB Corporation
PostgreSQL DBA
PostGIS for dummies
PostGIS for dummies – How PostGIS works? PostGIS is an open-source extension for the PostgreSQL database management system that adds spatial functionality for working with geographic data. It allows you to store, index, and query […]
PostgreSQL DBA
How to monitor PostgreSQL replication lag
PostgreSQL Advanced DBA Series: Monitoring PostgreSQL replication lag There are several ways to monitor replication lag in PostgreSQL: pg_stat_replication: This is a PostgreSQL system view that provides information about the replication status, including the replication lag. […]
PostgreSQL Troubleshooting
How to reduce replication lag with IO concurrency in Postgres 15
PostgreSQL 15 Advanced DBA Series: Troubleshooting PostgreSQL 15 replication lag with IO concurrency There are several ways to reduce replication lag with IO concurrency in PostgreSQL 15: Increase the number of parallel workers: PostgreSQL 15 […]
PostgreSQL DBA
What’s new with PostgreSQL 15?
PostgreSQL 15 new features PostgreSQL 15, the latest version of the popular open-source relational database management system, was released on October 3rd, 2021 and it comes with several new features and improvements: Parallelized Vacuum: PostgreSQL […]
Stopping PostgreSQL in an Emergency
How to stop PostgreSQL in an emergency? Sometimes DBAs need to stop PostgreSQL Server on an emergency notice. In such situations, DBAs cannot even wait for client connections to close gracefully, This post is for […]
Drop and Recreate PG_STAT_STATEMENTS in PostgreSQL
Drop and Recreate PG_STAT_STATEMENTS in PostgreSQL /* First we have to remove them from the extension */ ALTER EXTENSION pg_stat_statements DROP VIEW pg_stat_statements; ALTER EXTENSION pg_stat_statements DROP FUNCTION pg_stat_statements(boolean); /* Then we can drop them […]
Disabling SELinux
How to disable SELinux? Step 1: Open the SELinux configuration file: /etc/selinux/config. Step 2: Locate the following line: SELINUX=enforcing Step 3: Change the value to disabled: SELINUX=disabled Step 4: Save your changes and close the […]
Background Worker Processes in PostgreSQL
PostgreSQL Background Worker Processes PostgreSQL can be extended to run user-supplied code in separate processes. Such processes are started, stopped and monitored by postgres, which permits them to have a lifetime closely linked to the […]
MySQL SE Linux
MySQL and SE Linux Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system object. SELinux policy […]