PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Log messages:
> 2024-02-03 09:16:33.798 EST [3261686-102] app= LOG: background worker
> "parallel worker" (PID 2387431) was terminated by signal 11: Segmentation
> fault
> 2024-02-03 09:16:33.798 EST [3261686-103] app= DETAIL: Failed process was
> running: set max_parallel_workers=8; set work_mem='20GB';
It's hard to do anything with just the query. Can you put together a
self-contained test case, including table definitions and some sample
data? (The data most likely could be dummy generated data.)
It would also be useful to know what non-default settings you are
using.
regards, tom lane