Thread

Re: PostgreSQL 18 GA press release draft

Jonathan S. Katz <jkatz@postgresql.org> — 2025-09-12T02:21:42Z

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