The JusDB Database Engineering Blog

Design PostgreSQL HA with Patroni 4.1, a protected quorum DCS, HAProxy role checks, explicit durability choices, and rehearsed switchover and recovery.

A production guide to PostgreSQL full-text search — building tsvector generated columns, GIN indexes, multi-column search with setweight, ts_rank scoring, websearch_to_tsquery, and comparison against Elasticsearch.

A production guide to AWS RDS Proxy — how it works, when to use it, IAM authentication setup, and the connection pool sizing rules that prevent Lambda-induced database overload.

PostgreSQL PITR lets you recover your database to any point in time — down to the second — by replaying WAL segments on top of a base backup. Here's how to set it up correctly.

Monitor PostgreSQL streaming replication lag, replication slots, and standby health to ensure HA readiness

A production guide to TimescaleDB — hypertable setup, automatic chunk management, columnar compression policies, retention policies, continuous aggregates with time_bucket(), and comparison against InfluxDB and Prometheus.

A complete guide to PostgreSQL replication — streaming replication setup, logical replication for selective table sync, synchronous standby configuration, monitoring replication lag, and failover with Patroni.

Optimize AWS RDS PostgreSQL costs without sacrificing performance. Learn instance sizing, storage class selection, backup strategies, and Multi-AZ optimization.

Configure PostgreSQL logical replication for selective table sync, zero-downtime upgrades, and multi-tenant setups

Monitor MySQL and PostgreSQL with Prometheus, Grafana, and PMM. Covers mysqld_exporter, postgres_exporter, alert rules, and production dashboard configuration.

Secure your MySQL and PostgreSQL databases — TLS, at-rest encryption, role-based access, and audit logging

PgBouncer multiplexes thousands of application connections onto a small pool of real PostgreSQL server connections — reducing connection overhead without any application code changes.