PostgreSQL 19 Released

(postgresql.org)

44 points | by jkatz05 4 hours ago ago

5 comments

  • ddxv an hour ago ago

    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 an hour ago ago

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

  • vivzkestrel 3 hours ago ago

    - 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

    • hans_castorp an hour ago ago

      Nothing in those release notes refers to "key value stores"