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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org