Kbase 20175: Optimal Values of the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Solution ID: 20175
GOAL:
How To Determine Optimal Values of the -hash Startup Parameter.
FIX:
The default value for -hash is chosen to be a prime number approximately equal to one fourth of the number of database buffers (specified with the -B startup parameter).
The exact size of the hash table is not important, but its size should be a prime number. This will produce the most even distribution of buffer headers across hash chains.
Here are some useful values for the -hash parameter:
-B -hash
---- -----
1000 1009
1500 1511
2000 2003
2500 2503
3000 3001
3500 3511
4000 4001
4500 4507
5000 5003
6000 6007
7000 7001
8000 8009
9000 9001
10000 10007
11000 11003
-B -hash
---- -----
12000 12007
13000 13001
14000 14009
15000 15013
16000 16001
17000 17011
18000 18013
19000 19001
20000 20011
25000 25013
30000 30011
35000 35023
40000 40009
45000 45007
50000 50021
-B -hash
----- -----
60000 60013
70000 70001
80000 80021
90000 90001
100000 100003
110000 110017
120000 120011
130000 130003
140000 140009
150000 150001
160000 160001
170000 170003
180000 180001