|
26 | 26 | 'concurrent update: Read Committed: check default isolation level'); |
27 | 27 |
|
28 | 28 | $node->command_like( |
29 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 29 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
30 | 30 | --default-isolation-level=RC --file),$script ], |
31 | | -qr{processed:50/50}, |
| 31 | +qr{processed:12000/12000}, |
32 | 32 | 'concurrent update: Read Committed: check processed transactions'); |
33 | 33 |
|
34 | 34 | $node->command_like( |
35 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 35 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
36 | 36 | --default-isolation-level=RC --file),$script ], |
37 | 37 | qr{serialization failures: 0\(0\.000 %\)}, |
38 | 38 | 'concurrent update: Read Committed: check serialization failures'); |
|
45 | 45 | 'concurrent update: Repeatable Read: check default isolation level'); |
46 | 46 |
|
47 | 47 | $node->command_like( |
48 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 48 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
49 | 49 | --default-isolation-level=RR --file),$script ], |
50 | | -qr{processed:50/50}, |
| 50 | +qr{processed:12000/12000}, |
51 | 51 | 'concurrent update: Repeatable Read: check processed transactions'); |
52 | 52 |
|
53 | 53 | $node->command_like( |
54 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 54 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
55 | 55 | --default-isolation-level=RR --file),$script ], |
56 | | -qr{serialization failures: [1-9]\d*\([1-9]\d*\.\d* %\)}, |
| 56 | +qr{serialization failures: [1-9]\d*}, |
57 | 57 | 'concurrent update: Repeatable Read: check serialization failures'); |
58 | 58 |
|
59 | 59 | # Test transactions with Serializable default isolation level: |
|
64 | 64 | 'concurrent update: Serializable: check default isolation level'); |
65 | 65 |
|
66 | 66 | $node->command_like( |
67 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 67 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
68 | 68 | --default-isolation-level=S --file),$script ], |
69 | | -qr{processed:50/50}, |
| 69 | +qr{processed:12000/12000}, |
70 | 70 | 'concurrent update: Serializable: check processed transactions'); |
71 | 71 |
|
72 | 72 | $node->command_like( |
73 | | -[qw(pgbench --no-vacuum --client=5 --transactions=10 |
| 73 | +[qw(pgbench --no-vacuum --client=30 --transactions=400 |
74 | 74 | --default-isolation-level=S --file),$script ], |
75 | | -qr{serialization failures: [1-9]\d*\([1-9]\d*\.\d* %\)}, |
| 75 | +qr{serialization failures: [1-9]\d*}, |
76 | 76 | 'concurrent update: Serializable: check serialization failures'); |
