PostgreSQL

Tool · Text & code

strong

Mature, permissively licensed database; version 19 adds useful replica read-consistency.

PostgreSQL 19 released, about two months later than the usual September schedule

Why we say so

The PostgreSQL project says 19 shipped about two months later than the usual September schedule. Robert Haas, relayed by Simon Willison, attributes the delay mainly to a flurry of AI-reported vulnerabilities. Willison calls the new WAIT FOR LSN command, which gives read-your-writes consistency on standbys, his favorite feature.

Evidence

  1. Nov 19
    New WAIT FOR LSN command lets a standby wait for WAL replay to a given LSN, giving read-your-writes consistency
  2. Nov 19
    Willison calls WAIT FOR LSN his favorite new feature; store pg_current_wal_insert_lsn() in a cookie, then wait with an optional timeout before reading on a replica