Blog

No Picture
PostgreSQL Performance

How PostgreSQL Vacuum works?

How does PostgreSQL Vacuum work? In PostgreSQL, the vacuum process is responsible for reclaiming space from deleted or updated rows in tables. The vacuum process works by scanning the table and removing any rows that […]
No Picture
MySQL Performance

How to optimize indexes in MySQL

Optimizing Indexes in MySQL Indexes in MySQL are used to improve the performance of SELECT, UPDATE, and DELETE statements by reducing the amount of data that needs to be scanned. Properly optimizing indexes can help […]
No Picture
PostgreSQL DBA

How to implement Parallelized Vacuum in PostgreSQL 15?

How to implement Parallelized Vacuum in PostgreSQL 15? In PostgreSQL 15, the parallelized vacuum feature allows you to run multiple vacuum processes in parallel, which can significantly improve the performance of the vacuum operation. Here […]
No Picture
MySQL DBA

Quick Run-Book on MySQL Group Replication

The checklist for operating MySQL Group Replication MySQL Group Replication is a MySQL plugin that enables multiple MySQL servers to operate as a single, highly available, replicated cluster. This run-book on MySQL Group Replication provides [...]
No Picture
Linux Performance

How Queueing influence Linux performance?

How does queueing affect Linux Server performance? In Linux, queueing is implemented using a variety of different tools and mechanisms. Some of the most common tools and mechanisms used for queueing in Linux include: The […]
No Picture
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 […]