MIME-Version: 1.0
References: 
 <CANWCAZYzx7a7E9AY16Jt_U3+GVKDADfgApZ-42SYNiig8dTnFA@mail.gmail.com>
 <17F6CDF1-2D93-4C38-B0F2-D52B51F4D167@gmail.com>
 <CANWCAZbrKH-sDvzqb5z8BEofpXyXuN42UCRzoQ8wT3CiqPATFg@mail.gmail.com>
 <98232211-F000-45E6-AEE7-718834DDE277@gmail.com>
In-Reply-To: <98232211-F000-45E6-AEE7-718834DDE277@gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Thu, 30 Oct 2025 18:01:07 +1300
Message-ID: 
 <CAApHDvpGd-cHSr5OZ7_JpoTSWDBZAvAkarbkJPd0J3FW9zvFGw@mail.gmail.com>
Subject: Re: tuple radix sort
To: Chao Li <li.evan.chao@gmail.com>
Cc: John Naylor <johncnaylorls@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 Peter Geoghegan <pg@bowt.ie>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAApHDvpGd-cHSr5OZ7_JpoTSWDBZAvAkarbkJPd0J3FW9zvFGw%40mail.gmail.com>
Precedence: bulk

On Thu, 30 Oct 2025 at 16:46, Chao Li <li.evan.chao@gmail.com> wrote:
> > On Oct 30, 2025, at 11:40, John Naylor <johncnaylorls@gmail.com> wrote:
> > Are you by chance running with asserts on? It's happened before, so I
> > have to make sure. That makes a big difference here because I disabled
> > diversion thresholds in assert builds so that regression tests (few
> > cases with large inputs) cover the paths I want, in addition to my
> > running a standalone stress test.
>
> Yes, assert is always enabled in my sandbox. I can disable assert and rerun the test later.

Never expect anything meaningful to come from running performance
tests on Assert builds. You should always be rebuilding without
Asserts before doing performance tests.

David