Re: BUG #18902: TRAP:: failed Assert("!is_sorted") in File: "createplan.c"

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Tender Wang <tndrwang@gmail.com>

Cc: David Rowley <dgrowleyml@gmail.com>, n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org

Date: 2025-05-08T10:28:38Z

Lists: pgsql-bugs

On Sat, May 3, 2025 at 10:50 AM Tender Wang <tndrwang@gmail.com> wrote:
> Richard Guo <guofenglinux@gmail.com> 于2025年5月2日周五 15:03写道：
>> 0002 caches the number of presorted keys of the
>> outer path in MergePath, allowing us to save several calls to
>> pathkeys_count_contained_in.

> I quickly look through the 0002, it seems good to me.

I've also pushed 0002.  It's not a bug fix, but it can be considered a
complement to the work of 828e94c9d.  So it seems reasonable to
include it in v18 at this stage.

Thanks
Richard

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Track the number of presorted outer pathkeys in MergePath
- c06e909c26f0 18.0 landed
Suppress unnecessary explicit sorting for EPQ mergejoin path
- 773db22269d4 18.0 landed
Re-enable SSL connect_fails tests, and fix related race conditions.
- e0f373ee42a4 18.0 cited
Consider explicit incremental sort for mergejoins
- 828e94c9d2fd 18.0 cited