pg_ivm keeps a Postgres materialized view current without cron refreshes. What the README says about indexes, aggregates, locks and pg_dump, and what I'd test first.
A restic backup setup for a small VPS: encrypted snapshots off-server, Postgres dumps piped straight in, sane retention, a systemd timer, and a restore test.
ThinkingBox grades AI agents on the database they leave behind. Here is what its numbers show about silent failures, plus a Postgres harness to test…
The Postgres tuning parameters I adjust on every VPS I run, plus what PostgreSQL 19 Beta 4 changes for autovacuum, REPACK, and checkpoint tuning.
My mocked tests said the row level security policy was fine. It wasn't. How pgsql-test runs RLS policies under the real app role, and the…
The four pg_stat_statements queries I run before touching an index, why sorting by total time beats mean time, and what the extension can never tell…
plx lets you write a Postgres stored procedure in PHP, Go or Ruby that transpiles to plpgsql. I tried it, and here is where the…
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.
I switched a Next.js app from Prisma to Drizzle last spring. Here's how I now pick between the two TypeScript ORMs on real serverless projects.