pg_partman + pg_cron: Postgres 18 Auto Partitions (2026)
May 20, 2026
Tutorial: install pg_partman 5.4.3 + pg_cron on Postgres 18.4, configure daily range partitions with retention, automate maintenance, troubleshoot.
#postgres
LiteLLM Proxy Production Tutorial: LLM Gateway in 2026
May 19, 2026
Deploy LiteLLM Proxy v1.85 in production: Docker Compose, Postgres, virtual keys with budgets, fallback routing, and cost tracking for Claude, GPT, Gemini.
pgvector HNSW Postgres 18 Production Tuning Tutorial 2026
May 16, 2026
Tune pgvector 0.8.2 HNSW indexes on PostgreSQL 18: ef_search, halfvec quantization, iterative scans, and parallel builds with a runnable Docker setup.
pg-boss Tutorial: Postgres Job Queue in Node 24 (2026)
May 15, 2026
Production pg-boss tutorial. Queue jobs in Postgres from Node.js 24 with TypeScript, retries, dead-letter queues, cron, and graceful shutdown.
Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026
May 13, 2026
Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.
Production Postgres Pooling: PgBouncer + Supavisor 2026
May 7, 2026
Hands-on 2026 guide: PgBouncer 1.25.1 in front of Postgres 18, then swap to Supabase Supavisor — transaction pooling, prepared statements, and pitfalls.
Postgres LISTEN/NOTIFY: Real-Time Presence Tutorial 2026
May 5, 2026
Hands-on 2026 tutorial: build a real-time online-presence system on Postgres 18 LISTEN/NOTIFY with Node.js, Express, and ws — no Redis, no broker, just SQL.