2007-02-26

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(熱備援), 複寫機制叢集

沒有留言:

網誌存檔

PostgreSQL & Google-Analytics Running...

::Planet PostgreSQL::

PostgreSQL Information Page

PostgreSQL日記(日本 石井達夫先生Blog)

PostgreSQL News

黑喵的家 - 資料庫相關

Google 網上論壇
PostgreSQL 8 DBA 專業指南中文版
書籍內容討論與更多下載區(造訪此群組)
目錄下載: PostgreSQL_8 _DBA_Index_zh_TW.pdf (更新:2007-05-18)

全球訪客分佈圖(Google)

全球訪客分佈圖(Google)