Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
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 […]
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 […]
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 […]
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 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 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.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.
PostgreSQL 19 slipped, so plan the upgrade you can actually control: a logical replication cutover with sizing, rehearsal, runbook and rollback.
How-to for DBAs and developers: pg_dump formats, parallel restore, verification, and the errors that break 2 a.m. recoveries.
PostgreSQL 18’s B-tree skip scan lets multicolumn indexes serve queries that omit the leading column. Here’s how to read the plan, when it wins, and when it backfires.
