-- synchronous_commit = off
-- init
create unlogged table test3 (id integer not null primary key, val text);
insert into test3 (id, val)  select i , '!'|| i from generate_series(1, 10000000) as i;
select in_memory_btree_insert(i, i) from generate_series(1, 10000000) as i;

-- select_update_test3.sql
\set upper 10 * :scale
\set id1 random(1, :upper)
\set id2 random(1, :upper)

select * from test3 where id = :id1;
update test3 set val = '!' || :id1 where id = :id2;

-- select_update_btree.sql
\set upper 10 * :scale
\set id1 random(1, :upper)
\set id2 random(1, :upper)

select in_memory_btree_get(:id1);
select in_memory_btree_upsert(:id2, :id1);

-- $ pgbench -M prepared -c 4 -P 3 -s 1000000 -T 1000 -f select_update_btree.sql testdb
-- progress: 3.0 s, 35988.3 tps, lat 0.111 ms stddev 0.735
-- progress: 6.0 s, 31191.0 tps, lat 0.128 ms stddev 0.920
-- progress: 9.0 s, 31488.9 tps, lat 0.127 ms stddev 0.894
-- progress: 12.0 s, 31266.8 tps, lat 0.128 ms stddev 0.959
-- progress: 15.0 s, 30614.4 tps, lat 0.131 ms stddev 0.883
-- progress: 18.0 s, 28218.5 tps, lat 0.141 ms stddev 2.469
-- progress: 21.0 s, 31889.1 tps, lat 0.126 ms stddev 0.934
-- progress: 24.0 s, 30604.1 tps, lat 0.131 ms stddev 1.242
-- progress: 27.0 s, 32038.9 tps, lat 0.125 ms stddev 0.948
-- progress: 30.0 s, 30847.8 tps, lat 0.130 ms stddev 1.032
-- progress: 33.0 s, 30609.1 tps, lat 0.130 ms stddev 1.007

-- $ pgbench -M prepared -c 4 -P 3 -s 1000000 -T 1000 -f select_update_test3.sql testdb
-- progress: 3.0 s, 25938.3 tps, lat 0.154 ms stddev 0.834
-- progress: 6.0 s, 24918.0 tps, lat 0.160 ms stddev 0.907
-- progress: 9.0 s, 23436.9 tps, lat 0.171 ms stddev 1.867
-- progress: 12.0 s, 25321.8 tps, lat 0.158 ms stddev 0.901
-- progress: 15.0 s, 24628.2 tps, lat 0.162 ms stddev 1.061
-- progress: 18.0 s, 22869.4 tps, lat 0.175 ms stddev 1.012
-- progress: 21.0 s, 23341.4 tps, lat 0.172 ms stddev 1.047
-- progress: 24.0 s, 24103.8 tps, lat 0.166 ms stddev 0.872
-- progress: 27.0 s, 25767.8 tps, lat 0.155 ms stddev 0.842
-- progress: 30.0 s, 25090.8 tps, lat 0.159 ms stddev 0.872
-- progress: 33.0 s, 23343.8 tps, lat 0.171 ms stddev 0.998