Request a Demo
Home   >   mailing lists

Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation - Mailing list pgsql-bugs

From Christophe Pettus
Subject Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
Date
Msg-id 84B5D601-C007-4B07-9ECB-CDD06E47B949@thebuild.com
Whole thread Raw
In response to Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
List pgsql-bugs
Tree view 

> On Sep 20, 2025, at 14:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> While we've not gotten a huge amount of push-back about the top-level
> re-ordering, there's been some complaints.  So I'm not eager to
> propagate the idea further down.

And tangentially, doesn't the SQL standard make it implementation-defined if OR short-circuits or not?

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
Next
From: Tom Lane
Date:
Subject: Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation