Hacker news

  • Top
  • New
  • Past
  • Ask
  • Show
  • Jobs

PostgreSQL 19 Released (https://www.postgresql.org)

128 points by jkatz05 about 20 hours ago | 9 comments | View on ycombinator

ddxv about 18 hours 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.

_rwo about 2 hours ago |

excited about the build-in repack, that took a while

and thank you pg_repack, it's been a good ride!

perdy about 17 hours 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.

okc4pardon about 18 hours ago |

[flagged]

vivzkestrel about 19 hours ago |

[flagged]