Re: tuple radix sort - Mailing list pgsql-hackers

From David Rowley
Subject Re: tuple radix sort
Date
Msg-id CAApHDvpGd-cHSr5OZ7_JpoTSWDBZAvAkarbkJPd0J3FW9zvFGw@mail.gmail.com
Whole thread Raw
In response to Re: tuple radix sort  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: tuple radix sort
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)
Next
From: Chao Li
Date:
Subject: Re: tuple radix sort