Postgres configuration used for above testing:
shared_buffers = 40GB
max_worker_processes = 32
max_parallel_maintenance_workers = 24
max_parallel_workers = 32
synchronous_commit = off
checkpoint_timeout = 1d
max_wal_size = 24GB
min_wal_size = 15GB
autovacuum = off

System Configuration:
RAM:�������� 503GB
Disk Type:���� SSD
Disk Size:���� 1.6TB
Architecture: �� �� �� �� ��x86_64
CPU op-mode(s): �� �� �� ��32-bit, 64-bit
Byte Order: �� �� �� �� �� ��Little Endian
CPU(s): �� �� �� �� �� �� �� ��128
On-line CPU(s) list: �� 0-127
Thread(s) per core: �� ��2
Core(s) per socket: �� ��8
Socket(s): �� �� �� �� �� �� 8
NUMA node(s): �� �� �� �� ��8
Vendor ID: �� �� �� �� �� �� GenuineIntel
CPU family: �� �� �� �� �� ��6
Model: �� �� �� �� �� �� �� �� 47
Model name: �� �� �� �� �� ��Intel(R) Xeon(R) CPU E7- 8830 ��@ 2.13GHz
Stepping: �� �� �� �� �� �� ��2
CPU MHz: �� �� �� �� �� �� �� 1064.000
CPU max MHz: �� �� �� �� �� 2129.0000
CPU min MHz: �� �� �� �� �� 1064.0000
BogoMIPS: �� �� �� �� �� �� ��4266.62
Virtualization: �� �� �� ��VT-x
L1d cache: �� �� �� �� �� �� 32K
L1i cache: �� �� �� �� �� �� 32K
L2 cache: �� �� �� �� �� �� ��256K
L3 cache: �� �� �� �� �� �� ��24576K