Tag

#postgresql

10 posts

Backend DevelopmentAugust 27, 202643 min
Postgres Dead Tuples Not Being Removed: Fixes (2026)
Postgres dead tuples not being removed? VACUUM can only delete rows older than the xmin horizon. Here is how to find what holds it back, and how to fix it.
AI & Machine LearningJuly 17, 202615 min
Give an AI Agent Long-Term Memory with pgvector (2026)
Build a Claude agent with long-term memory: Postgres + pgvector store facts, cosine-similarity recall injects them back — verified across a process restart.
Backend DevelopmentJuly 2, 202614 min
Postgres MERGE RETURNING: Old and New Values (2026)
Postgres 18 lets MERGE RETURNING return old and new row values in one query. See merge_action(), the xmax alternative, and verified Node.js/TypeScript code.
Backend DevelopmentMay 20, 202611 min
pg_partman + pg_cron: Postgres 18 Auto Partitions (2026)
Tutorial: install pg_partman 5.4.3 + pg_cron on Postgres 18.4, configure daily range partitions with retention, automate maintenance, troubleshoot.
AI & Machine LearningMay 16, 202622 min
pgvector HNSW Postgres 18 Production Tuning Tutorial 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.
Backend DevelopmentMay 15, 202616 min
pg-boss Tutorial: Postgres Job Queue in Node 24 (2026)
Production pg-boss tutorial. Queue jobs in Postgres from Node.js 24 with TypeScript, retries, dead-letter queues, cron, and graceful shutdown.
Backend DevelopmentMay 13, 202616 min
Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026
Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.
Backend DevelopmentMay 7, 202618 min
Production Postgres Pooling: PgBouncer + Supavisor 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.
Backend DevelopmentMay 5, 202616 min
Postgres LISTEN/NOTIFY: Real-Time Presence Tutorial 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.
Backend DevelopmentSeptember 18, 202510 min
The Complete Guide to SQL: From Basics to Advanced Queries
SQL from beginner to advanced queries: CRUD, JOINs, subqueries, CTEs, Window Functions, indexes — covering Postgres, MySQL, and SQLite (most examples are portable; vendor-specific differences are noted where they apply).

Every post in #postgresql (10)