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.
Popular Searches
Featured Articles
Hand-picked by our editors
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.
Latest Articles
Showing 12 of 326 articles
MySQL to PostgreSQL Migration: Schema, Data, and Application Code Guide
Migrate from MySQL to PostgreSQL using pgLoader. Covers schema differences, type casting, application code changes, validation, and zero-downtime migration strategies.
pgBadger: PostgreSQL Log Analysis and Slow Query Reporting Guide
Learn how to use pgBadger to analyze PostgreSQL logs, find slow queries, and automate daily reporting. Includes postgresql.conf setup, cron automation, and RDS tips.
PostgreSQL Monitoring with Prometheus and postgres_exporter: A Production Guide
Set up PostgreSQL monitoring with Prometheus and postgres_exporter. Includes install steps, critical alert rules, Grafana dashboard panels, and custom query metrics.
PostgreSQL 16: New Features Every DBA Should Know
PostgreSQL 16 introduced logical replication from standbys, pg_stat_io, SQL/JSON constructors, COPY improvements, and pg_stat_checkpointer. Full DBA upgrade guide.
PostgreSQL Tablespaces: Moving Tables and Indexes Across Storage Tiers
Use PostgreSQL tablespaces to distribute tables and indexes across NVMe, SSD, and archive storage. Covers creation, ALTER TABLE SET TABLESPACE, monitoring, and backup.
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.
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.
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.
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.
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.
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.
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
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed