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
