Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\))
Subject: Re: tuple radix sort
From: Chao Li <li.evan.chao@gmail.com>
In-Reply-To: 
 <CANWCAZbrKH-sDvzqb5z8BEofpXyXuN42UCRzoQ8wT3CiqPATFg@mail.gmail.com>
Date: Thu, 30 Oct 2025 11:45:32 +0800
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 Peter Geoghegan <pg@bowt.ie>
Content-Transfer-Encoding: quoted-printable
Message-Id: <98232211-F000-45E6-AEE7-718834DDE277@gmail.com>
References: 
 <CANWCAZYzx7a7E9AY16Jt_U3+GVKDADfgApZ-42SYNiig8dTnFA@mail.gmail.com>
 <17F6CDF1-2D93-4C38-B0F2-D52B51F4D167@gmail.com>
 <CANWCAZbrKH-sDvzqb5z8BEofpXyXuN42UCRzoQ8wT3CiqPATFg@mail.gmail.com>
To: John Naylor <johncnaylorls@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/98232211-F000-45E6-AEE7-718834DDE277%40gmail.com>
Precedence: bulk


> On Oct 30, 2025, at 11:40, John Naylor <johncnaylorls@gmail.com> =
wrote:
>=20
> On Thu, Oct 30, 2025 at 8:56=E2=80=AFAM Chao Li =
<li.evan.chao@gmail.com> wrote:
>=20
>> I changed work_men to 1GB and reran the test. As the high cardinality =
data are still there, so I first reran with data:
>=20
>> With radix_sort on and off, execution time are almost the same.
>=20
> 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.
>=20

Yes, assert is always enabled in my sandbox. I can disable assert and =
rerun the test later.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/