## AMD 7945HX meson Zen4 CC=clang14.0.0-1ubuntu1.1 master drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 151.120901 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 147.177874 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 151.064370 (without initial connection time) meson Zen4 CC=clang14.0.0-1ubuntu1.1 tuple_deform_test 0001-0004 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 152.965042 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 154.980194 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 157.695297 (without initial connection time) meson Zen4 CC=clang14.0.0-1ubuntu1.1 tuple_deform_test 0001-0005 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 167.354056 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 167.484439 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 165.591389 (without initial connection time) meson CC=gcc11.4.0 master drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 159.966812 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 160.585879 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 160.184953 (without initial connection time) meson CC=gcc11.4.0 tuple_deform_test 0001-0004 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 192.087143 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 193.041584 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 195.771861 (without initial connection time) meson CC=gcc11.4.0 tuple_deform_test 0001-0005 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 193.295950 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 196.832431 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 193.384658 (without initial connection time) make CC=gcc11.4.0 master drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 184.257036 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 187.128967 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 190.110368 (without initial connection time) make CC=gcc11.4.0 tuple_deform_test 0001-0004 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 191.725243 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 196.491599 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 197.288260 (without initial connection time) make CC=gcc11.4.0 tuple_deform_test 0001-0005 drowley@LAPTOP-4UFF9TM8:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 188.464933 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 194.465085 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 195.769303 (without initial connection time) ## AMD3990x AMD3990x gcc13.2.0 master drowley@amd3990x:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 110.123444 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 108.975589 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 109.843548 (without initial connection time) AMD3990x gcc13.2.0 tuple_deform_test 0001-0004 drowley@amd3990x:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 127.368744 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 127.227820 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 127.290411 (without initial connection time) AMD3990x gcc13.2.0 tuple_deform_test 0001-0005 drowley@amd3990x:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 138.428092 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 137.714320 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 137.677846 (without initial connection time) AMD3990x clang18.1.3 master drowley@amd3990x:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 97.055680 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 96.971994 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 97.533476 (without initial connection time) AMD3990x clang18.1.3 tuple_deform_test 0001-0004 drowley@amd3990x:~$ ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 97.745050 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 98.439648 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 96.809416 (without initial connection time) AMD3990x clang18.1.3 tuple_deform_test 0001-0005 drowley@amd3990x:~$ ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 101.229381 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 100.246036 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 102.741080 (without initial connection time) ## Apple M2 drowley@Davids-Mac-mini ~ % echo Apple M2 master Apple M2 master drowley@Davids-Mac-mini ~ % ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 149.704897 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 149.413097 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 149.699362 (without initial connection time) drowley@Davids-Mac-mini ~ % echo Apple M2 tuple_deform_speedup 0001-0004 Apple M2 tuple_deform_speedup 0001-0004 drowley@Davids-Mac-mini ~ % ./deform_test.sh NOTICE: extension "pg_prewarm" already exists, skipping 100000 rows extra_cols 16 run 1 tps = 154.788546 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 154.803053 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 153.784874 (without initial connection time) drowley@Davids-Mac-mini ~ % echo Apple M2 tuple_deform_speedup 0001-0005 Apple M2 tuple_deform_speedup 0001-0005 drowley@Davids-Mac-mini ~ % ./deform_test.sh NOTICE: table "t1" does not exist, skipping 100000 rows extra_cols 16 run 1 tps = 169.057290 (without initial connection time) 100000 rows extra_cols 16 run 2 tps = 169.370318 (without initial connection time) 100000 rows extra_cols 16 run 3 tps = 169.376953 (without initial connection time)