Tag: postgres

Why apps fall over under load: pool size times replicas versus Postgres max_connections, restart herds, retry storms, timeouts, and the configs that fix them.

SurrealDB promises documents, graphs, search and realtime in one binary. I tested it against Postgres to see where that pitch holds up for self-hosters in 2026.

Stop watching osm2pgsql crawl. Tune flex output, slim mode, --cache, and Postgres for OSM imports on hardware that isn't a hyperscaler.

Compare DBeaver, pgAdmin, and DataGrip for PostgreSQL and MySQL management. Free vs commercial picks, feature breakdown.

Why PgBouncer matters for home lab Postgres, connection pooling modes explained, config examples, and when prepared statements break.

PostGIS turns Postgres into a spatial database you own. Import OpenStreetMap with osm2pgsql, run spatial queries, and serve your own tiles through Martin.

Run embeddings on Postgres with pgvector. Skip Chroma/Qdrant, tune IVFFlat vs HNSW indexes, build RAG pipelines locally.

Postgres replication at home: when you need read replicas, streaming vs logical replication explained, slot management, conflict handling.

pg_dump, pgBackRest, and WAL-G compared for Postgres backups. Point-in-time recovery, S3 setup, retention policy, and the restore drill to run today.

Docker volumes, version pinning, health checks, and tuning. A production-ready Postgres Compose template with init scripts and backup strategy.

How to safely add a NOT NULL column with a live backfill on a 200M-row Postgres table without locking your users out or scheduling any maintenance downtime.

Build a real Postgres 17 HA cluster with Patroni 4.x, etcd 3.5, and HAProxy, fully automatic failover, tested switchover procedure, zero manual babysitting.