|
13 | 13 | aqo.log_ignorance = 'on' |
14 | 14 | }); |
15 | 15 |
|
16 | | -#my $result1; |
17 | | - |
18 | 16 | $node->start(); |
19 | 17 |
|
20 | 18 | # Check conflicts of accessing to the ML knowledge base |
21 | 19 | # intelligent mode |
22 | 20 | $node->safe_psql('postgres',"CREATE EXTENSION aqo"); |
23 | 21 | $node->safe_psql('postgres',"ALTER SYSTEM SET aqo.mode = 'intelligent'"); |
24 | 22 | $node->command_ok(['pgbench','-i','-s','1' ],'init pgbench tables'); |
25 | | -$node->command_ok(['pgbench','-t',"1000",'-c',"20",'-j',"20" ], |
| 23 | +$node->command_ok(['pgbench','-t',"1000",'-c',"10",'-j',"10" ], |
26 | 24 | 'pgbench in intelligent mode'); |
27 | 25 |
|
28 | 26 | $node->safe_psql('postgres',"ALTER SYSTEM SET aqo.mode = 'controlled'"); |
29 | | -$node->command_ok(['pgbench','-t',"1000",'-c',"20",'-j',"20" ], |
| 27 | +$node->command_ok(['pgbench','-t',"1000",'-c',"10",'-j',"10" ], |
30 | 28 | 'pgbench in controlled mode'); |
31 | 29 |
|
32 | 30 | $node->safe_psql('postgres',"ALTER SYSTEM SET aqo.mode = 'disabled'"); |
33 | | -$node->command_ok(['pgbench','-t',"1000",'-c',"20",'-j',"20" ], |
| 31 | +$node->command_ok(['pgbench','-t',"1000",'-c',"10",'-j',"10" ], |
34 | 32 | 'pgbench in disabled mode'); |
35 | 33 |
|
36 | 34 | $node->safe_psql('postgres',"DROP EXTENSION aqo"); |
37 | 35 | $node->safe_psql('postgres',"CREATE EXTENSION aqo"); |
38 | 36 |
|
39 | 37 | $node->safe_psql('postgres',"ALTER SYSTEM SET aqo.mode = 'learn'"); |
40 | | -$node->command_ok(['pgbench','-t',"1000",'-c',"20",'-j',"20" ], |
| 38 | +$node->command_ok(['pgbench','-t',"1000",'-c',"10",'-j',"10" ], |
41 | 39 | 'pgbench in learn mode'); |
42 | 40 |
|
43 | 41 | $node->safe_psql('postgres',"ALTER SYSTEM SET aqo.mode = 'frozen'"); |
44 | | -$node->command_ok(['pgbench','-t',"1000",'-c',"20",'-j',"20" ], |
| 42 | +$node->command_ok(['pgbench','-t',"1000",'-c',"10",'-j',"10" ], |
45 | 43 | 'pgbench in frozen mode'); |
46 | 44 |
|
47 | 45 | $node->safe_psql('postgres',"DROP EXTENSION aqo"); |
|