Hi,
I am trying the PG 7.4 RC1 and RC2 and I see a superb performance
improvement compared with 7.3....
Explaining the querys, I see a change of planner that, in my case,
prefer Nested Loops in 7.4 opposite to Hash or Merge Join in 7.3.
To test, I disable Hash and Merge Joins in 7.3 and performance
have been very improved using nested loops...
Both systems are identical in configurations, properly vacuuned and
analyzed before tests.
Something can be wrong with my tests ? [ I desire that not :) ]
Alexandre