by Pratik Kumar Saha | Jul 23, 2026 | Blog, Database, PostgreSQL
SUMMARY: Learn why failed INSERT statements can still generate WAL in PostgreSQL, how this impacts production systems, and the key metrics to monitor and troubleshoot WAL growth. Table of contentsSUMMARY:IntroductionUnderstanding the BehaviorWhy It Matters in...
by Pratik Kumar Saha | Jun 18, 2026 | Blog, MySQL
SUMMARY: MariaDB Galera Cluster earns the label “virtually synchronous” because every node must receive and certify a transaction’s write set before the commit is acknowledged, yet nodes do not fully apply that transaction before the client sees...
by Pratik Kumar Saha | Feb 2, 2026 | Blog, PostgreSQL
SUMMARY: XTIVIA explores the complex reality of active-active PostgreSQL replication, evaluating modern tools such as EDB PGD and AWS pgactive to help organizations determine whether their high-availability requirements truly justify the added operational complexity....
by Pratik Kumar Saha | Jan 8, 2026 | Blog, PostgreSQL
SUMMARY: PostgreSQL utilizes TOAST (The Oversized-Attribute Storage Technique) to efficiently store large column values, though this mechanism can trigger performance-degrading disk spills during complex queries if not properly managed. TOAST automatically compresses...
by Pratik Kumar Saha | Jan 2, 2026 | Blog, PostgreSQL
Summary pgbench, PostgreSQL’s built-in benchmarking tool, enables organizations to accurately measure the impact of hardware upgrades by simulating realistic workloads to compare transactions per second (TPS) and latency before and after infrastructure changes....
by Pratik Kumar Saha | Dec 30, 2025 | Blog, PostgreSQL
Summary pg_createcluster provides a superior method for initializing PostgreSQL on Ubuntu compared to the traditional initdb command by automating critical system integrations and establishing a standardized directory structure that minimizes manual configuration...
