Tag: postgres

Leave most autovacuum globals alone, raise the cost limit, and give your one hot table a per-table scale_factor. Tested on postgres:18.6 with real numbers.

One Go shop app as a monolith and as gRPC microservices on the same pinned CPU cores. The monolith won every throughput test, and Postgres capped some loads.

pg_upgrade in link mode takes seconds. Logical replication takes planning. Here is when each wins, plus a tested Postgres 17 to 18 cutover with a rollback path.

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.