postgres version: PostgreSQL 15.8 (Raspbian 15.8-0+deb12u1) on arm-unknown-linux-gnueabihf, compiled by gcc (Raspbian 12.2.0-14+rpi1)
OS: Linux pi 6.6.31+rpt-rpi-v6 #1 Raspbian 1:6.6.31-1+rpt1 (2024-05-29) armv6l GNU/Linux
CPU: (/proc/cpuinfo)
name : ARMv6-compatible processor rev 7 (v6l)
BogoMIPS : 697.95
Features : half thumb fastmult vfp edsp java tls
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xb76
CPU revision : 7
Hardware : BCM2835
Revision : 000e
Serial : 00000000d75e7c8b
Model : Raspberry Pi Model B Rev 2
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.
This was reported in the past for MacOS, and the same workaround was reported to work in that case.
