Re: PostgreSQL 18 GA press release draft - Mailing list pgsql-hackers

From Jonathan S. Katz
Subject Re: PostgreSQL 18 GA press release draft
Date
Msg-id 56a4b3ff-fff3-4b8f-a8e2-b85ffc19b783@postgresql.org
Whole thread Raw
In response to Re: PostgreSQL 18 GA press release draft  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: PostgreSQL 18 GA press release draft
List pgsql-hackers
On 9/10/25 3:59 PM, Peter Geoghegan wrote:

> "It can also automatically transform queries with `OR` constructs in
> their `WHERE` clause into a logically equivalent IN() representation
> that can be pushed down to index scan nodes, leading to significantly
> faster execution".

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.

Jonathan

Attachment

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Reduce "Var IS [NOT] NULL" quals during constant folding
Next
From: Peter Geoghegan
Date:
Subject: Re: PostgreSQL 18 GA press release draft