"jungmin shin" <[EMAIL PROTECTED]> writes: > As I see the documentation of postgres, postgres use genetic algorithm for > query optimization rather than system R optimizer. right?
Only for queries with more than geqo_threshold relations. The join search algorithm for smaller queries is a System-R-like dynamic programming method. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq