Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-28 Thread Clemens Eisserer
Best regards, Clemens Am Di., 26. Dez. 2023 um 23:16 Uhr schrieb Thomas Munro : > > On Wed, Dec 27, 2023 at 5:17 AM Clemens Eisserer wrote: > > > FWIW, since this crash is inside LLVM you could presumably dodge the bug > > > by setting "jit" to off. > >

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-26 Thread Clemens Eisserer
Hi Tom, > FWIW, since this crash is inside LLVM you could presumably dodge the bug > by setting "jit" to off. Thanks, this indeed solved the crash. Just to make sure this crash doesn't have anything to do with my setup/config (I'd changed quite a few settings in postgresql.conf), I gave it a try

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Clemens Eisserer
> Does that install Postgres as part of the image or did you get it from > somewhere else? I installed it via "apt-get install postgresql" and it downloaded postgresql-15_15.5-0+deb12u1_arm64.deb - which seems to be the current package shipped with debian bookworm for arm64:

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Clemens Eisserer
Hi Adrian, > How did you upgrade? A fresh install based on "Raspberry Pi OS Lite" image provided (based on debian bookworm) with pgdump_all & plsql -f.

Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Clemens Eisserer
Hi, I've just updated my raspberry pi 3 from postgresql-13.3 on bullseye/armv6 to postgresq-15.5 on debian-bookworm/armv8. However after the upgrade, I experience reproducable crashes quering the following table: CREATE TABLE public.smartmeter ( leistungsfaktor real, momentanleistung