PostgreSQL 19 Released

jkatz05 102 points 7 comments November 19, 2026
www.postgresql.org · View on Hacker News

Discussion Highlights (3 comments)

vivzkestrel

- is the data inside postgres stored similar to this? https://www.nan.fyi/database - this article talks about key value stores, would relational follow the same method

ddxv

I respect their decision to delay a bit. Looking forward to trying it out. Especially this one: PostgreSQL 19 adds INSERT ... ON CONFLICT DO SELECT, which lets the RETURNING clause return existing rows that conflict with an insert, simplifying the common "get or create" pattern.

perdy

The ON CONFLICT DO SELECT looks like a good addition, getting the existing row back from RETURNING. No more second SELECT after DO NOTHING.

Semantic search powered by Rivestack pgvector
13,334 stories · 126,150 chunks indexed