Hi,
Dual Xeon P4 2.8
linux RedHat AS 3
kernel 2.4.21-4-EL-smp
2 GB ram
I can see the same problem:
procs memory swap io
system cpu
r b swpd free buff cache si so bi bo in cs us sy
id wa
1 0 0 96212 61056 1720240 0 0 0 0 101 11 25 0
75 0
1 0 0 96212 61056 1720240 0 0 0 0 108 139 25
0 75 0
1 0 0 96212 61056 1720240 0 0 0 0 104 173 25
0 75 0
1 0 0 96212 61056 1720240 0 0 0 0 102 11 25
0 75 0
1 0 0 96212 61056 1720240 0 0 0 0 101 11 25
0 75 0
2 0 0 96204 61056 1720240 0 0 0 0 110 53866 31
4 65 0
2 0 0 96204 61056 1720240 0 0 0 0 101 83176 41
5 54 0
2 0 0 96204 61056 1720240 0 0 0 0 102 86050 39
6 55 0
2 0 0 96204 61056 1720240 0 0 0 49 113 73642 41
5 54 0
2 0 0 96204 61056 1720240 0 0 0 0 102 84211 40
5 55 0
2 0 0 96204 61056 1720240 0 0 0 0 101 105165 39
7 54 0
2 0 0 96204 61056 1720240 0 0 0 0 103 97754 38
6 56 0
2 0 0 96204 61056 1720240 0 0 0 0 103 113668 36
7 57 0
2 0 0 96204 61056 1720240 0 0 0 0 103 112003 37
7 56 0
regards,
ivan.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
