The Postgres tuning parameters I adjust on every VPS I run, plus what PostgreSQL 19 Beta 4 changes for autovacuum, REPACK, and checkpoint tuning.
ubuntu-latest moves to Ubuntu 26.04 from 19 October. I diffed the two runner images: PHP 8.5, MySQL 8.4, Postgres 18, twelve tools gone, and a…
Postgres encryption at rest is two different questions. What LUKS already covers, what pg_vault_tde adds, what stays plaintext, and the 1.7.1 TOAST upgrade trap.
PostgreSQL never indexes foreign keys and Laravel's constrained() won't either. Vacuum 1.2 lints the schema in CI, with a baseline for legacy apps. What I…
I pointed Dalibo's PostgreSQL Migrator 1.0 at a 140-table MariaDB database. Inspection is superb, the COPY is fast, and one missing feature still costs a…
PostgreSQL Anonymizer 3.2 adds seeded pseudonymisation and blocks superuser masking. How I replaced a risky staging dump with a masked role, with the SQL.
pg_statviz 1.2 adds Postgres 19 support and a blocking locks module. How I monitor client databases with snapshots and a systemd timer instead of a…
pgvector plus HNSW replaced Pinecone on half my side projects. The schema, the index picks, hybrid search with FTS, and where I still reach for…
Real experience with Postgres full-text search in 2026: when tsvector and GIN indexes beat Elasticsearch, and the queries I actually ship in production.
JSONB in Postgres is great in the right place and a slow tax everywhere else. Here's the decision tree, indexing tips, and ORM patterns I…