计算机技术与发展2011，Vol.21Issue(8)：141-144,4.
PostgreSQL查询优化器分析研究
Analysis and Research on Optimizer of PostgreSQL
摘要
Abstract
As a representative of open-source database, PostgreSQL has been used more and more widely. The purpose is to study the work principle of PostgreSQL optimizer. Introduces die architecture of PostgreSQL and the workflow of the optimizer, then analyses the optimization principle. After that, dissect the two algorithms as well as their implementation details applied in PostgreSQL. Finally, gives an improved strategy based on MST. The conclusion is mat PostgreSQL's optimizer can handler arbitrarily complex SQL request and can give very reasonable execute path as soon as possible.关键词
PostgreSQL/查询优化/System-R/基因优化Key words
PostgreSQL/ optimizer /System-R/GEQO分类
信息技术与安全科学引用本文复制引用
孙振兴,向阳,刘增宝..PostgreSQL查询优化器分析研究[J].计算机技术与发展,2011,21(8):141-144,4.基金项目
国家自然科学基金资助项目(70771077) （70771077）
国家高技术研究发展计划(863计划)项目(2008AA04Z106) （863计划）
上海市科委项目(08DZ1122300) （08DZ1122300）
上海市信息化发展专项资金项目(200901015) （200901015）
