bench_v4.txt

text/plain
Filename: bench_v4.txt
Type: text/plain
Part: 0
Message: Re: Make tuple deformation faster
## 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)