PostgreSQL - 當前主要特點(簡報用)

修訂:2007-03-05

PostgreSQL features

主體:

• Transactions
• Subselects
• Views
• Foreign key referential integrity
• Sophisticated locking
• User-defined types
• Multi Server-side Languages support (PL/pgSQL, Java, Perl, Ruby, C/C++, ....)
  
• GIS data types <===特有的地理性資料類型庫
• Inheritance <== 被稱為"物件"關聯資料庫系統(O-RDBMS)的主因
• Rules
• MVCC(Multiple-version concurrency control)
• WAL(Write-Ahead Log)
  
• Native Microsoft Windows version
• Table spaces
• Ability to alter column types
• PITR(Point-in-time recovery)
• XML (8.3 Dev)
• Native GUI Admin Tool (support Slony-1)

8.2 Add

• Improved Warm standby databases
• Online index builds
• SQL2003 aggregates
• Improved TSearch2 with Generalized Inverted Indexes(GIN)
• Support for DTrace probes
• Advisory Locks
• New ISN/ISBN and pgCrypto modules
• Selective pg_dump options
  

HA(High-Availability)

• Higher performance (+20% on OLTP tests)
• Slony-1 複寫叢集系統
  
• pgmemcache 記憶體快取機制
  
• pgCluster 同步多主點叢集系統
• pgpool-II 連結池實作, Fail-Over(熱備援), 複寫機制叢集