The JusDB Database Engineering Blog

pgvector brings vector similarity search to PostgreSQL — enabling semantic search, recommendation engines, and RAG pipelines without a separate vector database.

A detailed comparison of PgBouncer, Odyssey, and pgcat for PostgreSQL connection pooling — architecture differences, threading models, pool modes, TLS support, and decision criteria for each workload type.

A practical guide to choosing between read replicas and caching layers — replication lag behavior, cache invalidation strategies, thundering herd prevention, tiered read architecture patterns, and decision framework.

Use pgvector for exact and approximate similarity search, relational filters, and hybrid retrieval while measuring recall, latency, storage, and write cost.

How to size your database connection pool correctly — the HikariCP formula, the variables that determine optimal pool size, and the mistakes that cause connection exhaustion or underutilization.

A production guide to zero-downtime database migrations — why ALTER TABLE causes downtime, the Expand-Contract pattern, safe migration patterns for PostgreSQL and MySQL, and tooling with Flyway, Liquibase, pt-osc, and gh-ost.

UUIDs as primary keys can destroy database performance. Learn why 50M rows went from 0.5ms to 2.3ms inserts, and how to fix it with hybrid approaches.

Detect query plan regressions in PostgreSQL using auto_explain, pg_hint_plan, and plan baseline management

Use pg_upgrade to migrate between PostgreSQL major versions — upgrade strategies, pre-checks, and rollback plans

A production guide to PostgreSQL Row Level Security — policy creation, USING vs WITH CHECK clauses, performance implications with indexes, and multi-tenant SaaS patterns with real schema examples.

Identify bloated indexes in PostgreSQL using pgstattuple, REINDEX CONCURRENTLY, and automated monitoring

Master AWS RDS connection limits for MySQL and PostgreSQL. Learn max_connections calculation, connection pooling strategies, and optimization techniques.