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…
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…
Valkey vs Redis in 2026: what the license fork actually changed, why the migration is a one-line container swap, and when I would still stay…
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…