Re: server crash on raspberry pi for large queries

Matthew Clark <mclark@drmatthewclark.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
diagnosticinformation is generated. 
> Workaround : this stops happening when jit_above_cost is set to -1 in postgresql.conf   After changing this setting
theproblem 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