Re: select big table postgresql crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jack Tseng <jacktsen(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: select big table postgresql crash
Date: 2020-03-09 16:25:33
Message-ID: 16103.1583771133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jack Tseng <jacktsen(at)gmail(dot)com> writes:
> postgresql 12.2
> install in MAC OS Catalina 10.15.3
> when table data big than 1G
> select * from big_table

> OS message
> =============================
> Termination Reason: Namespace CODESIGNING, Code 0x2

Yeah, Apple moved the goalposts recently and EDB's build hasn't caught
up; see

https://www.postgresql.org/message-id/CA+OCxoz0bWi+R2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt+bg@mail.gmail.com

Until there's a fix, I'd suggest "set jit = off".

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Logan Bowers 2020-03-09 21:05:27 Optimizer Doesn't Push Down Where Expressions on Rollups
Previous Message PG Bug reporting form 2020-03-09 16:24:51 BUG #16289: no installation data folder, launch deamon