jack <jack4pg@a7q.com> writes:
> Here is an excerpt of /var/log/postgresql/postgresql-16-main.log
> 2024-04-14 12:17:43.153 EDT [1227] LOG: server process (PID 7289) was terminated by signal 11: Segmentation fault
That's pretty interesting; it suggests an actual PG bug.
Can you get a stack trace from that? See
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
Also, it's probably time you showed us the complete DDL definition
for the tables you're working with. It's fairly hard to believe
this would happen without something rather out-of-the-ordinary
in the definitions. Or ... do you have any PG extensions installed?
regards, tom lane