| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> |
| Cc: | John Naylor <johncnaylorls(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie> |
| Subject: | Re: tuple radix sort |
| Date: | 2025-10-30 05:01:07 |
| Message-ID: | CAApHDvpGd-cHSr5OZ7_JpoTSWDBZAvAkarbkJPd0J3FW9zvFGw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 30 Oct 2025 at 16:46, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
> > On Oct 30, 2025, at 11:40, John Naylor <johncnaylorls(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chao Li | 2025-10-30 05:43:34 | Re: tuple radix sort |
| Previous Message | David Rowley | 2025-10-30 04:20:55 | Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) |