No Picture

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 […]

No Picture

Drop and Recreate PG_STAT_STATEMENTS in PostgreSQL

Drop and Recreate PG_STAT_STATEMENTS in PostgreSQL

No Picture

Disabling SELinux

How to disable SELinux? Step 1: Open the SELinux configuration file: /etc/selinux/config. Step 2: Locate the following line:

Step 3: Change the value to disabled:

Step 4: Save your changes and close the […]

No Picture

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 […]

No Picture

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 […]

No Picture

InnoDB Online DDL

InnoDB Online Schema Change (DDL) The online DDL feature provides support for in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table […]

No Picture

MySQL InnoDB ACID

InnoDB and the ACID Model The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the […]

No Picture

Consulting and Professional Services

MinervaDB Consulting and Professional Services We are an independent boutique private-label MySQL and MariaDB consulting services provider with several customers worldwide, Our MySQL and MariaDB consulting services team have travelled almost 40 cities worldwide for […]

No Picture

PostgreSQL Multicolumn Indexes

How Multicolumn Indexes are implemented in PostgreSQL? PostgreSQL supports Multicolumn indexes for performance and reliability. An index can be defined on more than one column of a table. For example, if you have a table […]

No Picture

PostgreSQL Indexes

How PostgreSQL Indexes works? PostgreSQL provides several index types: B-tree, Hash, GiST, SP-GiST, GIN and BRIN. Each index type uses a different algorithm that is best suited to different types of queries. By default, the […]