"jungmin shin" <jungmin(dot)shin(at)gmail(dot)com> 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