postgresql 12.2
install in MAC OS Catalina 10.15.3
when table data big than 1G
select * from big_table
postgresql crash
OS message
=============================
Process: postgres [3385]
Path: /Users/USER/*/postgres
Identifier: postgres
Version: ???
Code Type: X86-64 (Native)
Parent Process: postgres [184]
Responsible: postgres [184]
User ID: 503
Date/Time: 2020-03-09 15:02:39.708 +0800
OS Version: Mac OS X 10.15.3 (19D76)
Report Version: 12
Anonymous UUID: 3B113E91-898E-F666-BB50-31D9251329AE
Time Awake Since Boot: 1600 seconds
System Integrity Protection: enabled
Crashed Thread: 0 Dispatch queue: com.apple.main-thread
Exception Type: EXC_BAD_ACCESS (Code Signature Invalid)
Exception Codes: 0x0000000000000032, 0x000000010b21ea10
Exception Note: EXC_CORPSE_NOTIFY
Termination Reason: Namespace CODESIGNING, Code 0x2
kernel messages:
VM Regions Near 0x10b21ea10:
__LINKEDIT 000000010b217000-000000010b21e000 [ 28K] r--/rw- SM=COW /Users/USER/*/*.dylib
--> VM_ALLOCATE 000000010b21e000-000000010b220000 [ 8K] r-x/rwx SM=COW
__TEXT 000000010b223000-000000010ca9f000 [ 24.5M] r-x/rwx SM=COW /Users/USER/*/*.dylib
Application Specific Information:
crashed on child side of fork pre-exec
---
Jack Tseng