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)
- 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
- Higher performance (+20% on OLTP tests)
- Slony-1 複寫叢集系統
- pgmemcache 記憶體快取機制
- pgCluster 同步多主點叢集系統
- pgpool-II 連結池實作, Fail-Over(熱備援), 複寫機制叢集
沒有留言:
張貼留言