by Pratik Kumar Saha | Aug 20, 2026 | Blog, Database, Oracle, PostgreSQL
SUMMARY: Learn how Ora2Pg simplifies Oracle to PostgreSQL migration through schema conversion, assessment reports, and data migration. Table of contentsSUMMARY:IntroductionWhat is Ora2Pg?Why Use Ora2Pg?Start with an AssessmentDatabase Objects Supported by Ora2PgFinal...
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....
