OS: Debian Bullseye 5.10.0-23-amd64
Virtualized: Yes (Proxmox)
CPU: E5-2650 v2 @ 2.60GHz
Allocated Core Count: 16
Allocated RAM: 64 GiB PC3-12800R
Disk: Samsung PM983 1.92 TiB via Ceph
NOTE: Benchmarks were taken on a RAM disk mount, local to VM
Filesystem: XFS
Mount Options: defaults,noatime
Postgres Version: 15.3
Postgres Options (non-default):
shared_buffers = 16GB
max_wal_size = 8GB
Results (all times in milliseconds) Loaded 4000000 rows into each table
Statistics for various appends
Stats for pg_uuid_arr:
Runs: 6747.134 7133.889 10231.305 10714.742
Min: 6747.134
Max: 10714.742
Avg: 8706.767
StdDev: 1779.767
Stats for pg_uuid_chr_arr:
Runs: 10194.071 11503.284 10500.059 19441.640
Min: 10194.071
Max: 19441.640
Avg: 12909.763
StdDev: 3802.145
Stats for pg_identity_arr:
Runs: 4327.283 4747.486 4207.599 4321.452
Min: 4207.599
Max: 4747.486
Avg: 4400.955
StdDev: 205.680
Stats for pg_serial_arr:
Runs: 4475.196 5387.383 5079.210 6211.649
Min: 4475.196
Max: 6211.649
Avg: 5288.359
StdDev: 625.948
Stats for pg_identity_big_arr:
Runs: 4454.804 4820.864 4655.040 4675.806
Min: 4454.804
Max: 4820.864
Avg: 4651.628
StdDev: 130.361
Stats for pg_serial_big_arr:
Runs: 4845.931 6301.442 5148.145 6039.787
Min: 4845.931
Max: 6301.442
Avg: 5583.826
StdDev: 603.568
