Blog

No Picture
PostgreSQL Performance

Analyzing Index Bloat in PostgreSQL

Introduction: Index bloat can significantly impact the performance and storage efficiency of a PostgreSQL database. Therefore, to identify and understand the extent of index bloat, we can use the SQL query provided below. In this […]
No Picture
Linux Performance

How to troubleshoot thread contention happening to Linux Server?

Linux Thread Contention: How to Troubleshoot? Tip: Troubleshooting Linux thread contention often demands collaboration. Therefore, involve developers, system administrators, and performance engineers early to resolve issues efficiently and holistically.
No Picture
InnoDB

How is Cache Eviction implemented in InnoDB?

Understanding InnoDB Buffer Pool Management InnoDB manages cache eviction using an algorithm similar to the Least Recently Used (LRU) algorithm. However, this method is more complex than a simple LRU due to a feature called […]
No Picture
InnoDB

Troubleshooting Flush Locks in InnoDB

InnoDB Flush Locks InnoDB writes data to disk by using a method called “fuzzy checkpointing,” which spreads out writes to avoid sudden I/O bursts and maintain performance.  However, under certain circumstances, such as when there […]
No Picture
InnoDB

Tuning InnoDB history list performance

Tuning the InnoDB history list performance involves adjusting various parameters related to the purge process. The key parameters that can be tuned to optimize the history list performance in InnoDB are: To tune these parameters, follow […]
No Picture
PostgreSQL Internals

How does PostgreSQL I/O Work?

In PostgreSQL, I/O (Input/Output) refers to the process of reading and writing data to and from storage devices, such as hard disks or SSDs. PostgreSQL manages I/O operations to efficiently store and retrieve data. Here’s […]