PostgreSQL 9.6最新特性及未来展望（56页）.pdf

1、2016年云栖大会PostgreSQL专场技术交流群PostgreSQL 9.6New advances inFull Text SearchOleg BartunovPostgres Professional3PostgreSQL CORELocale supportPostgreSQL extendability:GiST(KNN),GIN,SP-GiSTFull Text Search(FTS)NoSQL(hstore,jsonb)Indexed regexp searchCustom AM&Generic WALPluggable table engines(WIP)Extension

2、s:Intarray,Hstore,LtreeMajor contributors to PostgreSQLCo-founders of Postgres ProfessionalAlexander Korotkov,Teodor Sigaev,Oleg Bartunov4AgendaInitial design of Postgres and innovationsHistory of some particular innovative features of PostgresFull Text Search in 9.6New RUM index5Original design of

3、PostgresThe main design goals of the new system are to:1)provide better support for complex objects,2)provide user extendibility for data types,operators and access methods,3)provide facilities for active databases(i.e.,alerters and triggers)and inferencing including forward-and backward-chaining,4)

4、simplify the DBMS code for crash recovery,5)produce a design that can take advantage of optical disks,workstations composed of multiple tightly-coupled processors,and custom designed VLSI chips,and6)make as few changes as possible(preferably none)to the relational model.*Stonebraker M.,Rowe L.A.The

5、design of Postgres.ACM,1986.15.2.340-355.6Original design of PostgresThe main design goals of the new system are to:1)provide better support for complex objects,2)provide user extendibility for data types,operators and access methods,3)provide facilities for active databases(i.e.,alerters and trigge

6、rs)and inferencing including forward-and backward-chaining,4)simplify the DBMS code for crash recovery,5)produce a design that can take advantage of optical disks,workstations composed of multiple tightly-coupled processors,and custom designed VLSI chips,and6)make as few changes as possible(preferab