JusDB
Free DB Audit

The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

404 canonical articlesBrowse the complete archive

Popular Searches

Featured Articles

Hand-picked by our editors

Analytics & OLAP· Featured

StarRocks Monitoring & Alerting: The Complete Production Guide

Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.

StarRocks14 minMar 24, 2026
Read

Latest Articles

Showing 12 of 404 articles

Zero-Downtime Schema Changes in PostgreSQL: Safe DDL Without Locking

Run PostgreSQL schema changes without locking: CREATE INDEX CONCURRENTLY, NOT VALID constraints, expand-contract column type changes, and lock_timeout. Covers pg_repack for table rewrites.

PostgreSQL13 minMar 5, 2026
Read

Oracle to PostgreSQL Migration: A Practical DBA Playbook

Migrate Oracle to PostgreSQL using ora2pg. Covers NUMBER→NUMERIC, DATE gotchas, PL/SQL→PL/pgSQL conversion, sequences, DUAL, NULL handling, and validation steps.

PostgreSQL12 minMar 5, 2026
Read

Patroni with Consul DCS: PostgreSQL HA Without etcd

Configure Patroni to use Consul instead of etcd as its DCS for PostgreSQL HA. Covers Consul setup, patroni.yml, service discovery, HAProxy routing, and failover testing.

PostgreSQL11 minMar 5, 2026
Read

pg_cron: Scheduling Automated Jobs Inside PostgreSQL

Use pg_cron to schedule SQL jobs inside PostgreSQL. Covers installation, cron syntax, partition maintenance, materialized view refresh, job monitoring, and RDS setup.

PostgreSQL12 minMar 5, 2026
Read

From Standalone to High Availability: Convert Your PostgreSQL Database to a Patroni Cluster

Learn how to convert a standalone PostgreSQL instance to a Patroni high-availability cluster with etcd. Step-by-step guide covering installation, configuration, and failover testing.

PostgreSQL12 minMar 4, 2026
Read

Aurora I/O-Optimized vs Standard: When to Switch and How Much You Save

Learn exactly when to switch Aurora from Standard to I/O-Optimized storage — with the break-even formula and a worked cost example using db.r6g.8xlarge with 10 TB storage.

AWS7 minFeb 25, 2026
Read

SQL Server on Linux: Production Setup, Performance, and HA

Run SQL Server on Linux in production — container vs bare metal, performance parity, AG on Pacemaker, and monitoring

SQL Server9 minFeb 24, 2026
Read

Migrating from Oracle to SQL Server: A Practical Checklist

Migrate Oracle workloads to SQL Server — data type mapping, PL/SQL conversion, SSMA tooling, and validation strategies

SQL Server9 minFeb 23, 2026
Read

SQL Server Query Store: Identifying and Fixing Plan Regressions

Use SQL Server Query Store to catch bad execution plans, force stable plans, and automate query performance regression alerts

SQL Server8 minFeb 22, 2026
Read

SQL Server Always On Availability Groups: Setup and Tuning

Configure SQL Server Always On AG — listener routing, synchronous vs asynchronous commit, failover policy, and monitoring

SQL Server9 minFeb 21, 2026
Read

Apache Pinot vs ClickHouse vs Druid: Real-Time OLAP Comparison

Compare Pinot, ClickHouse, and Druid for real-time analytics — ingestion latency, query patterns, and operational cost

ClickHouse7 minFeb 20, 2026
Read

Apache Pinot Architecture Deep Dive: Segments, Indexes, and Brokers

Understand Apache Pinot internals — segment lifecycle, StarTree indexes, broker routing, and controller operations

Pinot10 minFeb 19, 2026
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed