Blog
Thoughts on DevOps, database engineering, and the art of automation.
Database
PostgreSQL DBA Conversation: "You Know That One Big DELETE Could Hurt Production, Right?"
A senior PostgreSQL DBA's warning on why a single bulk DELETE can trigger WAL growth, replication lag, dead tuples, and locking issues — plus the batch-delete, partitioning, and retention strategies that keep production safe.
Jul 2, 20264 min read
Big Data
Understanding the Relationship Between HDFS fsimage and Cloudera Reports Manager Heap Size
If Cloudera Manager's Reports Manager is consuming high CPU or memory, the root cause is often improper heap sizing relative to your HDFS namespace size (fsimage).
Mar 14, 20263 min read
Big Data
How to Solve the Hive Small File Problem in Hadoop (Practical Guide for Production Clusters)
10,000 files × 1 MB is far worse than 100 files × 128 MB for the same total data. Here's how to detect, prevent, and fix the small file problem in production Hive clusters.
Mar 9, 20265 min read