The JusDB Database Engineering Blog

A production guide to Citus — distributed PostgreSQL for horizontal sharding. Hypertable setup, distribution column selection, colocation for local joins, reference tables, and Citus vs native PostgreSQL partitioning.

pg_partman automates PostgreSQL partition lifecycle. This guide covers create_parent(), retention policies, partition pruning, and migrating existing tables without downtime.

Stream PostgreSQL changes to Kafka using pgoutput and Debezium — setup, monitoring, and lag management

Tune PostgreSQL checkpoint frequency, WAL segment size, and bgwriter to maximize write throughput

Learn how JusDB optimized a TimescaleDB cluster ingesting billions of IoT readings monthly, achieving 10× faster writes and 65% storage reduction.

Implement schema change management with versioning, peer review, and automated validation for safe deployments

A complete guide to MySQL JSON functions — JSON column type, JSON_EXTRACT and arrow operators, JSON_SET vs JSON_INSERT vs JSON_REPLACE vs JSON_MERGE_PATCH, functional indexes, and multi-valued indexes for arrays.

Patroni automates PostgreSQL failover using a distributed consensus store like etcd. Learn how to configure Patroni for production-grade HA.

Build a data-driven capacity planning process using historical metrics, growth trends, and resource modeling

Evaluate Google AlloyDB — columnar engine, read pool nodes, ML integration, and comparison with Aurora PostgreSQL

A deep dive into PostgreSQL JSONB vs JSON storage formats, GIN and B-tree indexing strategies, containment operators, and the performance characteristics that determine which to use for document storage workloads.

A production guide to Amazon Aurora PostgreSQL — the shared storage architecture, fast failover mechanics, Aurora Serverless v2 ACU scaling, Global Database, Parallel Query, and an honest comparison against standard RDS.