Orbit
Xstreami
Database Insights, Tips & Expert Blogs
PostgreSQL 19: A Smarter Way to Enable Logical Decoding with effective_wal_level
Author : Jethish
October 06, 2026
PostgreSQL 19 introduces effective_wal_level, allowing logical decoding to be enabled dynamically when required, without changing wal_level or restarting the PostgreSQL server.
PostgreSQL Indexing: B-Tree, GIN, BRIN and When Each One Actually Helps
Author : Jethish
September 29, 2026
Learn how to choose the right PostgreSQL index for better query performance. This guide explains B-Tree, GIN, and BRIN indexes, their ideal use cases, performance characteristics, and key indexing best practices to help optimize PostgreSQL databases efficiently.
PostgreSQL Replication Setup: Step-by-Step Guide for Streaming Replication and Failover
Author : Jethish
September 16, 2026
Understand how PostgreSQL streaming replication works, deploy a primary server and replica node, implement failover for high availability, and optimize your replication setup with Mafiree's expert DBA services. Ensuring high availability and data protection in PostgreSQL environments is critical for modern applications. One of the most effective ways to achieve this is through PostgreSQL replication setup, particularly using streaming replication with failover capabilities. This guide walks you through configuring a robust PostgreSQL replication system, covering everything from basic setup to handling failover scenarios.
REPACK in PostgreSQL 19: Finally, Online Table Bloat Removal in Core
Author : Jethish
September 10, 2026
PostgreSQL 19 introduces REPACK, a native command that unifies the functionality of VACUUM FULL and CLUSTER while adding support for CONCURRENTLY to minimize downtime. Unlike traditional table rewrites that require long ACCESS EXCLUSIVE locks, REPACK can reclaim table bloat online by copying live data, rebuilding indexes, and applying concurrent changes before a final metadata swap. This article explores how REPACK works internally, compares it with VACUUM FULL and pg_repack, demonstrates a hands-on performance test, explains the new pg_stat_progress_repack monitoring view, and covers current limitations and best practices for production environments.
ProxySQL vs HAProxy for MySQL High Availability: Complete Comparison 2026
Author : Shenbaga Varna S
August 04, 2026
ProxySQL excels in MySQL-specific query routing, read/write splitting, and performance tuning. HAProxy offers robust load balancing across multiple protocols and is ideal for general-purpose proxying. Choose ProxySQL if your focus is on MySQL optimization; select HAProxy for broader application-level load balancing. Both tools support failover mechanisms but with different levels of database-specific integration.
Tracking PostgreSQL Operations in Real Time: A Deep Dive into PostgreSQL Progress Reporting
Author : Jethish
September 10, 2026
This blog explores PostgreSQL’s progress reporting system views that provide real-time visibility into long-running operations like VACUUM, ANALYZE, CREATE INDEX, COPY, and base backups. It explains how DBAs can monitor execution phases, estimate completion, detect bottlenecks, and improve operational efficiency using these built-in views. Real-world examples and use cases demonstrate how progress tracking enhances performance tuning, automation, and maintenance planning.
Key Differences Between MySQL and PostgreSQL: Architecture, Performance & Use Cases
Author : Jethish
April 06, 2026
Understanding the difference between MySQL and PostgreSQL is critical when choosing a database for production workloads. While both are powerful open-source relational databases, they are built with fundamentally different philosophies. This comprehensive guide compares MySQL vs PostgreSQL across architecture, performance behavior under concurrent loads, replication strategies, and real-world use cases — backed by Mafiree's 17+ years of hands-on production experience across India, APAC, and the Middle East.
AWS Database Storage Optimization: How We Reclaimed 3.6 TB and Cut Costs in Half
Author : sukan
March 18, 2026
A client came to us with a classic AWS database storage optimization problem: 15.2 TB allocated, less than a third actually in use — and a bill that kept growing regardless. Within one week, Mafiree had reclaimed 3.6 TB, validated a safe path to cut allocation nearly in half, and executed a zero-downtime migration. Here's the full story.
PostgreSQL Connection Pooling: PgBouncer vs Odyssey – Performance & Configuration
Author : Jethish
January 28, 2026
PostgreSQL uses a process-per-connection model, which can limit scalability in high-traffic environments. Connection poolers help manage this challenge by reusing database connections efficiently. This blog compares PgBouncer and Odyssey, two popular PostgreSQL connection poolers, highlighting their architecture, performance characteristics, configuration differences, and ideal use cases. It helps organizations choose the right pooling solution based on workload scale, complexity, and operational requirements.
Highlights
More than 6000 Servers Monitored
Happy Clients
Certified DBAs
24 x 7 x 365 Support
Contacts
Nagercoil Office
Miru IT Park, Vallankumaranvillai,
Nagercoil, Tamilnadu - 629 002.
Bangalore Office
Unit 303, Vanguard Rise,
5th Main, Konena Agrahara,
Old Airport Road, Bangalore - 560 017.
Call: +91 6383016411
Email: sales@mafiree.com