ONQU INTELLIGENCE
News archive
Every story ONQU has published, searchable by organisation, vendor, technology or keyword. Stories move here after seven days in the live feed and stay here permanently.
3 stories found
-
Database Vendors
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…
Planet PostgreSQL ·
-
Cloud Migration · Database Vendors
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…
Planet PostgreSQL ·
-
Database Vendors · Data Security & Resilience
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…
Planet PostgreSQL ·