Horton

Re: PostgreSQL 18 GA press release draft

Peter Geoghegan <pg@bowt.ie>

View thread
From: Peter Geoghegan <pg@bowt.ie>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-12T02:25:55Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add modern SHA-2 based password hashes to pgcrypto.

  2. Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate

  3. Allow usage of match_orclause_to_indexcol() for joins

On Thu, Sep 11, 2025 at 10:21 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
> Thanks for the detailed explanation, I'm proposing:
>
> "It can also optimize queries that use `OR` conditions in a `WHERE` to
> use an index, leading to significantly faster execution."
>
> since the mechanism of the transformation is less important, but the
> outcome is that people can benefit from the previous optimziation
> without having to rewrite their queries.

Sounds good.

Thanks
-- 
Peter Geoghegan