From: Christophe Pettus <xof@thebuild.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: jinhui.lai@qq.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
Date: Sat, 20 Sep 2025 15:54:54 -0700
Message-ID: <84B5D601-C007-4B07-9ECB-CDD06E47B949@thebuild.com> (raw)
In-Reply-To: <2510592.1758403162@sss.pgh.pa.us>
References: <19059-c751eed385314309@postgresql.org>
<2510592.1758403162@sss.pgh.pa.us>
> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: xof@thebuild.com, tgl@sss.pgh.pa.us, jinhui.lai@qq.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19059: PostgreSQL fails to evaluate the cheaper expression first, leading to 45X performance degradation
In-Reply-To: <84B5D601-C007-4B07-9ECB-CDD06E47B949@thebuild.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox