"jungmin shin" <jungmin.shin@xxxxxxxxx> 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
