The JusDB Database Engineering Blog

Tune PostgreSQL 18 WAL and checkpoints without weakening crash safety: understand commit modes, measure checkpointer deltas, and validate archive recovery.

A practical guide to hardening PostgreSQL: configure SSL/TLS, tighten pg_hba.conf, implement least-privilege roles, enable row-level security, and set up audit logging.

Upgrade PostgreSQL major versions with sub-second downtime using logical replication. Step-by-step guide covering schema copy, subscription setup, lag monitoring, and sequence resync.

PostgreSQL 17 ships eager freezing and improved autovacuum prioritization, the most significant vacuum improvements in a decade. Learn how to tune autovacuum for high-write tables and prevent transaction ID wraparound.

Use pg_repack to reclaim PostgreSQL table bloat without the exclusive lock of VACUUM FULL. Covers installation, table vs index repack, disk space requirements, and throttling.

Implement least-privilege access in PostgreSQL with role hierarchies, ALTER DEFAULT PRIVILEGES, schema separation, and privilege auditing queries.

Configure PostgreSQL TLS with self-signed or CA-signed certificates. Force TLS via pg_hba.conf, set minimum TLS version, and verify server certs from clients.

PostgreSQL 17 is one of the most impactful releases in years. Incremental backups, vacuum improvements, logical replication failover slots, and planner enhancements are all production-critical changes.

Use PostgreSQL EXPLAIN and EXPLAIN ANALYZE safely, interpret estimates and runtime evidence, and test the smallest change that addresses the real bottleneck.

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

PostgreSQL views historically executed with the owner's privileges, bypassing row-level security policies. PostgreSQL 15 fixed this with security_invoker views — here's why it matters and how to use it in multi-tenant schemas.

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