Elizabeth Garrett Christensen: Query Plan Hints in PostgreSQL 19: How & When to Use Advice
Query hints: You asked for it, Postgres 19 gave it to you. Now, they are just waiting to see how you use it. For years the Postgres community was against adding support for hints. They felt if you had correctly analyzed tables, the Postgres query planner would make the right choice. And they're not wrong, for the most part. Yet…
Devrim GÜNDÜZ: RHEL / Rocky Linux / AlmaLinux repository RPMs now follow the OS minor version
Since I started building packages separately on each supported RHEL minor version, there has been a repository RPM for each minor version (9.6, 9.7, 9.8, 10.0, ...) in addition to the one for the major versio (9, 10). All of them share the same package name, and the minor version specific ones are also published in the repository of the…
Stefan Fercot: pgBackRest and PostgreSQL failover: why archive_mode matters
A recent question on the community channels described a difficult situation: a standby had been promoted with archive_mode=off, and restarting the new primary was something the team wanted to avoid. Could they enable archiving on a downstream standby and take a pgBackRest backup from there instead? Their attempt failed with archive_mode must be enabled, even with archive-mode-check=n. Removing the checks…