Обсуждение: select big table postgresql crash

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