---
format: "aidr-story-markdown/v1"
id: "a457925fbd609abe8fd65471755023c6eafadcbcedf77ee83bc9ad7aec976502"
canonical_url: "https://aidr.today/a457925f?lang=vi"
title: "PostgreSQL 19 Released"
lang: "en"
requested_lang: "vi"
available_langs: ["en"]
translation_fallback: "en"
fallback_fields: ["title","summary"]
published_at: "2026-11-19T20:43:57.000Z"
category: "Open Source"
topics: ["open-source"]
source_urls: ["https://simonwillison.net/2026/Nov/19/postgresql-19/"]
summary: "PostgreSQL 19 Released Most years PostgreSQL ships a new release in September, but this year's release came two months later thanks mainly to the flurry of issues that the PostgreSQL team needed to address as part of the ongoing AI-reported vulnerability apocalypse. This release was definitely worth the wait. My favorite new feature is this one: For applications that send reads to standbys, PostgreSQL 19 adds \"read-your-writes\" consistency with the new WAIT FOR LSN command. A session on a standby can use WAIT FOR LSN to wait until the standby has replayed the write-ahead log (WAL) up to a specific log sequence number (LSN) before running a query, so the application can read data it just wrote on the primary. In practice, that looks like this: UPDATE movie SET genre = 'Dramatic' WHERE genre = 'Drama'; SELECT pg_current_wal_insert_lsn(); That returns a value like 0/0306EE20 ."
---

# PostgreSQL 19 Released

> [Open the canonical story](<https://aidr.today/a457925f?lang=vi>)

**Published:** 2026-11-19T20:43:57.000Z
**Category:** Open Source
**Topics:** open\-source

_English fallback used for: title, summary._

## Summary

PostgreSQL 19 Released Most years PostgreSQL ships a new release in September, but this year's release came two months later thanks mainly to the flurry of issues that the PostgreSQL team needed to address as part of the ongoing AI\-reported vulnerability apocalypse\. This release was definitely worth the wait\. My favorite new feature is this one: For applications that send reads to standbys, PostgreSQL 19 adds "read\-your\-writes" consistency with the new WAIT FOR LSN command\. A session on a standby can use WAIT FOR LSN to wait until the standby has replayed the write\-ahead log \(WAL\) up to a specific log sequence number \(LSN\) before running a query, so the application can read data it just wrote on the primary\. In practice, that looks like this: UPDATE movie SET genre \= 'Dramatic' WHERE genre \= 'Drama'; SELECT pg\_current\_wal\_insert\_lsn\(\); That returns a value like 0/0306EE20 \.

## Sources

- [Story source](<https://simonwillison.net/2026/Nov/19/postgresql-19/>)

