Tag: postgres

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.

Self-host map tiles with PostGIS. Import OSM data, query spatial data, serve tiles via Martin. No Google Maps tax.

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.

Compare pg_dump, pgBackRest, and WAL-G for Postgres backups. Point-in-time recovery, S3 setup, and restore drills.

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

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.

Learn to read Postgres EXPLAIN ANALYZE output without losing your mind. Costs, row estimates, buffer hit stats, and the index and query fixes that matter most.

Run PostgreSQL 18 on ZFS for atomic snapshots, lz4 compression, and silent corruption detection. Tuning guide, backup automation scripts, and the real pitfalls.

SQLite is brilliant until you need concurrent writes, replication, or online migrations. Here's the actual line where Postgres earns its keep.

A kernel upgrade halved one team's PostgreSQL throughput. The fix was kernel tuning: huge pages, THP, swappiness, I/O scheduler. Here's what matters and why.