OVERCLOCK.news
developer

PostgreSQL 19 released

The PostgreSQL Global Development Group has announced the release of PostgreSQL 19.

BlueskyXRedditMail
Why am I seeing this Ranked on source trust — LWN

It ranks mainly on source trust: LWN is the most reliable outlet we track on this subject, and is the only one on the story so far.

Single-sourced. No second organisation has confirmed it yet.

Link-outLink-out, because only one organisation carries it and no first-party source is on it. Link-out means we point at the publisher and say nothing of our own.

Blended score 0.523 — every figure below is computed, none of it is editorial.
FactorWeightScore ContributionWhere it came from
Corroboration 0.35 0.39 +0.135 26% 1 independent org on the story. Tier-3 aggregators never corroborate — they can show something is circulating, never that it is true.
Source trustleads 0.25 0.85 +0.212 41% LWN is the highest-trust source on this story. Trust is taken from the best source, not averaged.
Pickup rate 0.20 0.00 +0.000 0% One counted organisation, so there is no spread to measure — nothing has picked this up to set a rate.
Freshness 0.20 0.88 +0.176 34% Halves every 10 hours from the newest item on the story. This is the only factor that rewards a story for nothing more than being recent.

Corroboration counts distinct organisations, once each, and only from tiers 1 and 2. Freshness halves every 10 hours, so this ranking is a snapshot and will differ at the next build.

1stpangu · CC BY-SA 4.0 · Wikimedia Commons · illustrative
Read the full article at Lwn →
The story Written by OVERCLOCK from the sources below

PostgreSQL 19 is now available. The release includes a new REPACK (CONCURRENTLY) command that allows table optimization without interrupting active operations. A fresh pg_plan_advice extension gives administrators better visibility into query plans and performance stability. The update also delivers various performance improvements across the system.

Several features were removed from this version during development. The PostgreSQL Global Development Group documented these changes in the official release notes, which provide complete details on all modifications included in version 19.

Administrators should review the full release notes before upgrading to understand which features have been removed and how the new tools may affect their existing deployments and workflows.

What happened

The PostgreSQL Global Development Group has announced the release of PostgreSQL 19. Notable features in this release include the introduction of the REPACK (CONCURRENTLY) command to optimize tables without disruption to ongoing operations, better control over plan stability and query performance with the new pg_plan_advice extension, and a number of performance improvements. In September, LWN covered the removal of several features initially slated for this release. See the release notes for a full list of new features and changes.

1independent orgs
52story score
0velocity
85source trust
5passes seen

How this story arrived

Ordered by when each source was first observed, which is what the velocity figure is computed from. Publishers backdate; observed order does not.

  1. 01 Lwn first seen PostgreSQL 19 released

Overclock clusters coverage from independent sources and grades it automatically. The figures above are computed, not editorial. This page summarises and links to reporting by the outlets named — follow the links for the original work.