The JusDB Database Engineering Blog

Fine-tune PostgreSQL autovacuum to eliminate dead tuples, prevent table bloat, and maintain query performance

Use MySQL Performance Schema to profile queries, monitor memory, and diagnose bottlenecks without guesswork

Decode PostgreSQL wait events to diagnose lock contention, I/O bottlenecks, and CPU pressure in production

How to use pg_stat_statements to identify slow queries, analyze execution stats, and optimize PostgreSQL performance

Five counterintuitive database performance truths every engineer gets wrong — over-indexing costs, N+1 queries, connection pool sizing, replica reads, and EXPLAIN limitations.

Guide the PostgreSQL query planner with enable_xxx settings, pg_hint_plan extension, and extended statistics for correlated columns. Fix bad plans without rewriting queries.

Benchmark MySQL with sysbench OLTP workloads. Covers setup, read/write and read-only suites, interpreting TPS and 95th percentile latency, and comparing before/after changes.

Use pgbench to benchmark PostgreSQL before and after configuration changes. Covers scale factor selection, TPC-B and read-only workloads, custom SQL scripts, and latency percentiles.

Enable and tune PostgreSQL parallel query for analytical workloads. Covers max_parallel_workers settings, PARALLEL SAFE functions, JIT compilation, and execution plan verification.

Connection exhaustion is one of the most common causes of database downtime at scale. Here is how production teams use PgBouncer and ProxySQL to handle 10,000+ concurrent connections.

Implement MySQL table partitioning with RANGE and HASH strategies. Covers instant partition drops for data lifecycle, partition pruning verification, and key gotchas.

Explore PostgreSQL 18 revolutionary features including async I/O, improved parallelism, enhanced JSON support, and developer experience improvements coming in 2025.