{"id":6384,"date":"2018-01-19T19:35:45","date_gmt":"2018-01-19T19:35:45","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/postgresql-database-server-8-1-0-officially-released\/"},"modified":"2018-01-19T19:36:24","modified_gmt":"2018-01-19T19:36:24","slug":"postgresql-database-server-8-1-0-officially-released","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/postgresql-database-server-8-1-0-officially-released\/","title":{"rendered":"PostgreSQL Database Server 8.1.0 Officially Released"},"content":{"rendered":"
\n
\n
By Ken Lin<\/div>\n
on November 28, 2005<\/div>\n<\/p><\/div>\n
Designed, built and tested by a large and thriving community and backed by a growing number of corporate sponsors and support companies, version 8.1 will expand the scope of PostgreSQL application development.<\/p>\n

The new release includes performance improvements and advanced SQL features which will support larger data warehouses, higher-volume transaction processing and more complex distributed enterprise software.<\/p>\n

New features in this release include:<\/p>\n

Roles:
\nPostgreSQL now supports database roles, which simplify the management of large numbers of users with complex overlapping database rights.<\/p>\n

IN\/OUT Parameters:
\nPostgreSQL functions now support IN, OUT and INOUT parameters, which substantially improves support of complex business logic for J2EE and .NET applications.<\/p>\n

Two-Phase Commit (2PC):
\nLong in demand for WAN applications and heterogeneous data centers using PostgreSQL, this feature allows ACID-compliant transactions across widely separated servers.<\/p>\n

Some Performance Enhancements found in this release include:<\/p>\n

Improved Multiprocessor (SMP) Performance:
\nThe buffer manager for 8.1 has been enhanced to scale almost linearly with the number of processors, leading to significant performance gains on 8-way, 16-way, dual-core, and multi-core CPU servers.<\/p>\n

Bitmap Scan:
\nIndexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables.<\/p>\n

Table Partitioning:
\nThe query planner is now able to avoid scanning whole sections of a large table using a technique known as Constraint Exclusion.<\/p>\n

Shared Row Locking:
\nPostgreSQL’s “better than row-level locking” now supports even higher levels of concurrency through the addition of shared row locks for foreign keys.<\/p>\n

PostgreSQL 8.1.0 can be downloaded from the following locations:<\/p>\n

FTP Mirrors
\n– http:\/\/www.postgresql.org\/ftp\/latest\/<\/a><\/p>\n

-Windows Installer
\n– http:\/\/www.postgresql.org\/ftp\/binary\/v8.1.0\/win32<\/a><\/p>\n

Other Binaries, including Linux, Mac OSx and Solaris
\n– http:\/\/www.postgresql.org\/ftp\/binary\/v8.1.0\/<\/a><\/p>\n

Installation guideline for PostgreSQL Mac OS X version :
http:\/\/developer.apple.com\/internet\/opensource\/postgres.html<\/a><\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Designed, built and tested by a large and thriving community and backed by a growing number of corporate sponsors and support companies, version 8.1<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6384","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=6384"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6384\/revisions"}],"predecessor-version":[{"id":7209,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6384\/revisions\/7209"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=6384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=6384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=6384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}