by Pratik Kumar Saha | Sep 3, 2026 | Blog, Database, PostgreSQL
SUMMARY: Explore when not to use B-Tree indexes in PostgreSQL and how GIN, GiST, SP-GiST, and BRIN can deliver better performance for specialized workloads. Table of contentsSUMMARY:Introduction1. B-Tree: The Default Workhorse2. GIN: Searching Inside Composite Data3....
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...
