PostgreSQL (64-bit)

最新版本 PostgreSQL 9.6.0 (64-bit)

PostgreSQL 9.6.0 (64-bit)

PostgreSQL 9.6.0 (64-bit)
PostgreSQL 64 位是一個功能強大的開源對象關係數據庫系統。它擁有超過 15 年的積極開發和經過驗證的架構,在可靠性,數據完整性和正確性方面贏得了良好聲譽。它運行在所有主要的操作系統上,包括 Linux,UNIX(AIX,BSD,HP-UX,SGI IRIX,Mac OS X,Solaris,Tru64)和 Windows。  PostgreSQL 64 位是一個功能強大的對象關係數據庫管理系統!下載 PostgreSQL 脫機安裝程序安裝 64 位的 PC!

它完全符合 ACID,完全支持外鍵,連接,視圖,觸發器和存儲過程(多語言)。它包括大多數 SQL:2008 數據類型,包括 INTEGER,NUMERIC,BOOLEAN,CHAR,VARCHAR,DATE,INTERVAL 和 TIMESTAMP。它還支持存儲二進制大對象,包括圖片,聲音或視頻。它具有用於 C / C ++,Java,.Net,Perl,Python,Ruby,Tcl,ODBC 等的本地編程接口,以及特殊的文檔(表大小可以達到 32TB).

也可用:下載 PostgreSQL for Mac


檔案版本 PostgreSQL 9.6.0 (64-bit)

檔案名稱 postgresql-9.6.0-1-windows-x64.exe
檔案大小 137 MB
系統 Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64
軟體類型 開源軟體
作者 PostgreSQL Global Development Group
更新日期 2016-09-30

What's new in this version:

- This release will allow users to both scale up and scale out high performance database workloads. New features include parallel query, synchronous replication improvements, phrase search, and improvements to performance and usability, as well as many more features.

Scale Up with Parallel Query:
- Version 9.6 adds support for parallelizing some query operations, enabling utilization of several or all of the cores on a server to return query results faster. This release includes parallel sequential (table) scan, aggregation, and joins. Depending on details and available cores, parallelism can speed up big data queries by as much as 32 times faster.
- "I migrated our entire genomics data platform - all 25 billion legacy MySQL rows of it - to a single Postgres database, leveraging the row compression abilities of the JSONB datatype, and the excellent GIN, BRIN, and B-tree indexing modes. Now with version 9.6, I expect to harness the parallel query functionality to allow even greater scalability for queries against our rather large tables," said Mike Sofen, Chief Database Architect, Synthetic Genomics.

Scale Out with Synchronous Replication and postgres_fdw:
- Two new options have been added to PostgreSQL's synchronous replication feature which allow it to be used to maintain consistent reads across database clusters. First, it now allows configuring groups of synchronous replicas. Second, the "remote_apply" mode creates a more consistent view of data across multiple nodes. These features support using built-in replication to maintain a set of "identical" nodes for load-balancing read workloads.
- The PostgreSQL-to-PostgreSQL data federation driver, postgres_fdw, has new capabilities to execute work on remote servers. By "pushing down" sorts, joins, and batch data updates, users can distribute workload across multiple PostgreSQL servers. These features should soon be added to other FDW drivers.
- "With the capabilities of remote JOIN, UPDATE and DELETE, Foreign Data Wrappers are now a complete solution for sharing data between other databases and PostgreSQL. For example, PostgreSQL can be used to handle data input going to two or more different kinds of databases," said Julyanto Sutandang, Director of Business Solutions at Equnix.

Better Text Search with Phrases:
- PostgreSQL's full text search feature now supports "phrase search." This lets users search for exact phrases, or for words within a specified proximity to each other, using fast GIN indexes. Combined with new features for fine-tuning text search options, PostgreSQL is the superior option for "hybrid search" which puts together relational, JSON, and full text searching.

Smoother, Faster, and Easier to Use:
- Thanks to feedback and testing by PostgreSQL users with high-volume production databases, the project has been able to improve many aspects of performance and usability in this release. Replication, aggregation, indexing, sorting, and stored procedures have all been made more efficient, and PostgreSQL now makes better use of resources with recent Linux kernels. Administration overhead for large tables and complex workloads was also reduced, especially through improvements to VACUUM.

Other Features:
- New system views and functions: pg_stat_wal_receiver, pg_visibility, pg_config, pg_blocking_pids, pg_notification_queue_usage
- Command progress reporting support
- Cascade support for installing extensions
- pg_basebackup concurrency and replication slot support
- Wait Event support
- View editing and crosstabs in psql
- User-defined expiration for old snapshots
- Index-only scans for partial indexes

PostgreSQL 9.6.0 (64-bit) 相關參考資料
Download PostgreSQL (64bit) 9.6.0 for windows -

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL 9.6.0 (64-bit) Download for Windows Change Log ...

What's new in this version: - This release will allow users to both scale up and scale out high performance database workloads. New features include parallel query, synchronous replication improv...

PostgreSQL: Downloads

Downloads. PostgreSQL Core Distribution. The core of the PostgreSQL object-relational database management system is available in several source and binary formats.

PostgreSQL: Windows installers

PostgreSQL Version, 64 Bit Windows Platforms, 32 Bit Windows Platforms. 10, 2016, 2012 R2 & R1, 2008 R2, 7, 8, 10, 2008 R1, 7, 8, 10. 9.6, 2012 R2 & R1, 2008 R2, 7, 8, 10, 2008 R1, 7, 8, 10. 9...