Re: server crash on raspberry pi for large queries

Matthew Clark <mclark(at)drmatthewclark(dot)com> writes:
> issue: when issuing a large query ,  e.g.   "Select count(*) from temperature" on a table with > 150M rows the system crashes.
>   example error:   LOG:  server process (PID 20037) was terminated by signal 4: Illegal instruction  no more diagnostic information is generated.
> Workaround : this stops happening when jit_above_cost is set to -1 in postgresql.conf   After changing this setting the problem stops.

What this sounds like is a memory leak in the JIT stuff. We fixed
one such issue last year, but perhaps there's more. Can you provide
a self-contained test case? Also, please be more specific about
which Linux version you are using, and which LLVM version.

regards, tom lane