What's new in this version: Major enhancements include: - Built-in replication based on log shipping. This advance consists of two features: Streaming Replication, allowing continuous archive (WAL) files to be streamed over a network connection to a standby server, and Hot Standby, allowing continuous archive standby servers to execute read-only queries. The net effect is to support a single master with multiple read-only slave servers. - Easier database object permissions management. GRANT/REVOKE IN SCHEMA supports mass permissions changes on existing objects, while ALTER DEFAULT PRIVILEGES allows control of privileges for objects created in the future. Large objects (BLOBs) now support permissions management as well. - Broadly enhanced stored procedure support. The DO statement supports ad-hoc or "anonymous" code blocks. Functions can now be called using named parameters. PL/pgSQL is now installed by default, and PL/Perl and PL/Python have been enhanced in several ways, including support for Python3. - Full support for 64-bit Windows. - More advanced reporting queries, including additional windowing options (PRECEDING and FOLLOWING) and the ability to control the order in which values are fed to aggregate functions. - New trigger features, including SQL-standard-compliant per-column triggers and conditional trigger execution. - Deferrable unique constraints. Mass updates to unique keys are now possible without trickery - Exclusion constraints. These provide a generalized version of unique constraints, allowing enforcement of complex conditions. - New and enhanced security features, including RADIUS authentication, LDAP authentication improvements, and a new contrib module passwordcheck for testing password strength. - New high-performance implementation of the LISTEN/NOTIFY feature. Pending events are now stored in a memory-based queue rather than a table. Also, a "payload" string can be sent with each event, rather than transmitting just an event name as before. - New implementation of VACUUM FULL. This command now rewrites the entire table and indexes, rather than moving individual rows to compact space. It is substantially faster in most cases, and no longer results in index bloat. - New contrib module pg_upgrade to support in-place upgrades from 8.3 or 8.4 to 9.0. - Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins. This helps optimize some automatically-generated queries, such as those produced by object-relational mappers (ORMs). - EXPLAIN enhancements. The output is now available in JSON, XML, or YAML format, and includes buffer utilization and other data not previously available. - hstore improvements, including new functions and greater data capacity.
PostgreSQL 9.0.0 (64-bit) 相關參考資料
Download PostgreSQL 9.0.0 for Windows
PostgreSQL 9.0.0 · File Size: 44.90 MB · Date Released: Add info · Works on: Windows 2000 / Windows 2000 x64 / Windows 7 / Windows 7 x64 / Windows 8 / Windows 8 ...
http://www.oldversion.com
Downloading PostgreSQL 9.0.0 (64-bit) from FileHorse.com
A powerful, open source relational database system · PostgreSQL 9.0.0 (64-bit) · Key details about this download. The file will be downloaded ...
https://www.filehorse.com
Downloads
PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it ...
https://www.postgresql.org
Herunterladen PostgreSQL 9.0.0 for - Windows
PostgreSQL 9.0.0 ; Dateigröße: 44.90 MB ; Veröffentlichung: Hinzufügen Infos ; Works on: Windows 2000 / Windows 2000 x64 / Windows 7 / Windows 7 x64 / Windows 8 / ...
http://www.oldversion.com.de
PostgreSQL 9.0 Download - pgAdmin3.exe
2024年4月28日 — PostgreSQL version 9.0 (pgAdmin3.exe). PostgreSQL is an open source object-relational database system, which uses and extends the SQL ...
https://postgresql.informer.co
PostgreSQL 9.0 Final Release Available Now!
2010年9月20日 — PostgreSQL 9.0 Final Release Available Now! · Hot standby · Streaming replication · In-place upgrades · 64-bit Windows builds · Easy mass permissions ...
https://www.postgresql.org
PostgreSQL: Release Notes
2010年9月20日 — It is believed all still-supported platforms have working 64-bit integer data types. E.24.3. Changes. Version 9.0 has an unprecedented number of ...
https://www.postgresql.org
README.mb.big5
Breadcrumbs. postgres-provanence; /postgresql-9.0.0; / ... 簡介MB 支援是為了讓PostgreSQL 能處理多位元組字元 ... 64. 65. 66. 67. 68. 69. 70. 71. 72. 73. 74. 75. 76.
https://github.com
[翻譯] PostgreSQL 9.0 Beta 1 發佈
2023年12月5日 — [翻譯] PostgreSQL 9.0 Beta 1 發佈 · Hot standby 及Streaming replication · 支援64 位元Windows 系統 · 加強的LISTEN/NOTIFY 可加快資料庫內部的事件訊息 ...
https://cyberjos.blog
下载PostgreSQL 9.0.0 for - 旧版本的软件- OldVersion.com
文件大小: 44.90 MB; 发布日期: 添加信息; 工程于: Windows 2000 / Windows 2000 x64 / Windows 7 / Windows 7 x64 / Windows 8 / Windows 8 x64 / Windows 98 ...
http://www.oldversion.cn
|