Dasha 1.8 Tutorial: Postgres Index Advice and Schema Lint
Install Dasha 1.8 against your Postgres fleet with a read-only role, then use index recommendations, schema lint and the pg_stat_io I/O page safely.
Month: 3 weeks ago
PgBouncer 1.26: Patch Three CVEs, Then Kill p99 Timeouts
PgBouncer 1.26.0 fixes three pre-auth DoS CVEs and adds per-database query_wait_timeout plus pool_idle_timeout. Here is how to tune both for tail latency.
PostgreSQL 19 Beta 4 Pulls Features: What Houston DBAs Need
PostgreSQL 19 Beta 4 landed on September 24, 2026 — right on the date the project’s own schedule named. The headline is not a feature that arrived. It is four that left. Per the release announcement, this beta reverted SQL/PGQ property graph query support, online enabling and disabling of data checksums, temporal updates and deletes […]
Postgres Hybrid Search for RAG: pgvector + tsvector + RRF
Every RAG prototype works on twenty documents. Then the real corpus shows up with its real shape: maintenance procedures that cite API 610, drilling reports that name a PZ-7 mud pump, permits and work orders full of tag numbers. Ask a pure vector index for “PZ-7 liner torque” and it cheerfully returns five documents about […]
Postgres Failover and archive_mode: Why Backups Break
Most failover drills end the same way: the standby takes over, applications reconnect, and everyone goes home. The part that quietly broke is backup continuity. A community question summarized this week by Stefan Fercot on his pgBackRest blog describes exactly this: a standby was promoted with archive_mode=off, and the team wanted to avoid restarting the […]
pgsql-test Tutorial: Real Postgres Tests for RLS and Triggers
Step-by-step setup for pgsql-test: seed an ephemeral Postgres database, test row-level security in both directions, and assert on triggers and constraint violations inside your existing test runner.
pg_stat_statements Blind Spots: Why Slow Queries Vanish
pg_stat_statements evicts least-executed statements, splits or merges queryids by parse tree, hides nested work, and has no application_name column. A DBA triage guide for Postgres 17, 18, and 19.
PostgreSQL 19 Delayed: Houston DBA Guide to the New Schedule
PostgreSQL 19 slipped past its usual September GA. Here’s the new schedule, the features that were reverted, and how Houston DBAs should re-plan the upgrade window.
pg_partman 5.5 + pg_cron: Automate Partition Maintenance
pg_partman 5.5.0 changed its background worker’s default role, and pg_cron 1.6.8 added Postgres 19 support. Here is how to run partition maintenance that does not go quiet.
Zero-Downtime Postgres Upgrade: Logical Replication Cutover
PostgreSQL 19 slipped, so plan the upgrade you can actually control: a logical replication cutover with sizing, rehearsal, runbook and rollback.