michail-nikolaev

import java.nio.file.Files
import java.nio.file.Paths
import kotlin.io.path.name

fun main(args: Array<String>) {

    val benchmarksDir = "/home/nkey/pg/pg_bench"
    val avgBenchmarksDir = "/home/nkey/pg/pg_bench/avg"
    val versionToRuns: MutableMap<String, MutableList<List<Long>>> = mutableMapOf()

michail-nikolaev

git format-patch -4 -v2 --patience

michail-nikolaev

# Configuration arguments for vcbuild.
use strict;
use warnings;

our $config = {
	asserts => 1,    # --enable-cassert

	# blocksize => 8,         # --with-blocksize, 8kB by default
	# wal_blocksize => 8,     # --with-wal-blocksize, 8kB by default
	ldap      => 1,        # --with-ldap

michail-nikolaev

BEGIN;

select * from pgbench_accounts order by aid desc limit 1;

END;

michail-nikolaev

vanilla:

init: 475Mb

1-minute: 496MB
number of transactions actually processed: 34833

3-minute (+2): 
545MB
number of transactions actually processed: 52537

michail-nikolaev

D:\Dev\postgres\performance_testing\venv\Scripts\python.exe D:/Dev/postgres/performance_testing/venv/performance_test.py
scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps	ration
drop init alter update update2 index done
10	True	True	True	1.0	1.0	simple	16084.824297	15388.997799	0.9567401865788625
10	True	True	True	1.0	0.75	simple	15370.750825000001	14833.028435	0.9650165176625326
10	True	True	True	1.0	0.5	simple	14791.773803	14404.691221000001	0.9738312262508035
10	True	True	True	1.0	0.25	simple	12808.263731	12850.738076000001	1.0033161672723214
10	True	True	True	1.0	0.1	simple	9411.683004	10041.923368	1.0669636199744663
10	True	True	True	1.0	0.01	simple	3116.8491840000006	4165.333495	1.3363923786823813
drop init alter update update2 index done

michail-nikolaev

D:\Dev\postgres\performance_testing\venv\Scripts\python.exe D:/Dev/postgres/performance_testing/venv/performance_test.py
scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps	ration
start...waiting...done
drop init alter update update2 index warm
test 0 = 8601 test 1 = 8591 test 2 = 8545 test 3 = 8572 test 4 = 8515 test 5 = 8579 fin
start...waiting...done
warm
test 0 = 8688 test 1 = 8695 test 2 = 8689 test 3 = 8633 test 4 = 8605 test 5 = 8731 fin
10	True	False	True	1.0	1.0	prepared	8674	8567	0.9876642840673276
start...waiting...done

michail-nikolaev

D:\Dev\postgres\performance_testing\venv\Scripts\python.exe D:/Dev/postgres/performance_testing/venv/performance_test.py
scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps	ration
start...waiting...done
drop init alter update update2 index warm
test 0 = 8209 test 1 = 8218 test 2 = 8153 test 3 = 8284 test 4 = 8305 test 5 = 8337 fin
start...waiting...done
warm
test 0 = 8622 test 1 = 8598 test 2 = 8697 test 3 = 8683 test 4 = 8672 test 5 = 8697 fin
10	True	False	True	1.0	1.0	prepared	8661	8251	0.9526613555016742
start...waiting...done

michail-nikolaev

scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps	
10	True	False	True	1.0	1.0	simple	5460	5249	0,961355311
10	True	False	True	1.0	1.0	prepared	8777	8349	0,951236185
10	True	False	True	1.0	0.66	simple	5258	5171	0,983453785
10	True	False	True	1.0	0.66	prepared	8210	7874	0,9590743
10	True	False	True	1.0	0.33	simple	4756	4638	0,975189235
10	True	False	True	1.0	0.33	prepared	6941	6701	0,96542285
10	True	False	True	1.0	0.1	simple	3325	3237	0,973533835
10	True	False	True	1.0	0.1	prepared	4275	4190	0,980116959
10	True	False	True	1.0	0.01	simple	1113	1099	0,987421384

michail-nikolaev

scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps
10	True	False	True	1.0	1.0	simple	5428	5276
10	True	False	True	1.0	0.66	simple	5237	5039
10	True	False	True	1.0	0.33	simple	4673	4560
10	True	False	True	1.0	0.1	simple	3248	3164
10	True	False	True	1.0	0.01	simple	1093	1075
10	True	False	True	0.95	1.0	simple	5412	5264
10	True	False	True	0.95	0.66	simple	5191	5019
10	True	False	True	0.95	0.33	simple	4526	4463
10	True	False	True	0.95	0.1	simple	3029	2993