From: | Matthew Clark <mclark(at)drmatthewclark(dot)com> |
---|---|
To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | server crash on raspberry pi for large queries |
Date: | 2024-08-20 00:45:30 |
Message-ID: | 2123352386.9759142.1724114730509@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sindhu S | 2024-08-20 03:37:18 | Re: Report Postgres Bug - Unlogged table sequence |
Previous Message | Andrei Lepikhov | 2024-08-19 19:16:22 | Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for |