|
17 | 17 | my$shard1 = get_new_node("shard1"); |
18 | 18 | $shard1->init; |
19 | 19 | $shard1->append_conf('postgresql.conf',qq( |
20 | | -max_prepared_transactions =300 |
| 20 | +max_prepared_transactions =30 |
21 | 21 | log_checkpoints = true |
22 | 22 | shared_preload_libraries = 'pg_tsdtm' |
23 | 23 | )); |
|
26 | 26 | my$shard2 = get_new_node("shard2"); |
27 | 27 | $shard2->init; |
28 | 28 | $shard2->append_conf('postgresql.conf',qq( |
29 | | -max_prepared_transactions =300 |
| 29 | +max_prepared_transactions =30 |
30 | 30 | log_checkpoints = true |
31 | 31 | shared_preload_libraries = 'pg_tsdtm' |
32 | 32 | )); |
|
52 | 52 | diag("done$host$port"); |
53 | 53 | } |
54 | 54 |
|
55 | | -$shard1->psql('postgres',"insert into accounts select 2*id-1, 0 from generate_series(1,10000) as id;"); |
56 | | -$shard2->psql('postgres',"insert into accounts select 2*id, 0 from generate_series(1,10000) as id;"); |
| 55 | +$shard1->psql('postgres',"insert into accounts select 2*id-1, 0 from generate_series(1,10010) as id;"); |
| 56 | +$shard2->psql('postgres',"insert into accounts select 2*id, 0 from generate_series(1,10010) as id;"); |
57 | 57 |
|
58 | 58 | diag($master->connstr() ); |
59 | 59 | # sleep(3600); |
|
81 | 81 | $oldtotal =$total; |
82 | 82 | diag("Isolation error. Total =$total"); |
83 | 83 | } |
| 84 | +diag("Total =$total"); |
84 | 85 | } |
85 | 86 |
|
86 | 87 | $master->pgbench_await($pgb_handle); |
|