Research on the Mechanism of Query Optimization in the PostgreSQL
Chang Liu · 2005
As the most powerful and complex free DBMS with the most features, PostgreSQL not only draws the DBMS researchers' developers' attention, but also is adopted in commerce more and more. It seems that it has a very promising future. This article discusses the implementation of the Query Optimization of the PostgreSQL, and analyzes the kernel part of the optimizer, the generating and choosing of the execution path. And, it points out a shortage of the optimization arithmetic.