PostgreSQL 9.1 released
“Among all the open source DBMSs, PostgreSQL 9.1 provides several of the most advanced industrial capabilities and is supported by an energetic and innovative community with proven success with the consumer. PostgreSQL is a well-proven solution for installing and running applications in the cloud, ”said Charles Fan, senior vice president of research and development at VMware.
Information for users
Several features that users have been asking for over the years have been added to PostgreSQL 9.1, which eliminates obstacles in deploying new or ported applications to PostgreSQL. Among them:
')
“Heroku provides the world's largest PostgreSQL database service as a service,” said James Lindenbaum, co-founder of Heroku, “Release of version 9.1 with synchronous data replication gives our customers the ability to protect critical information and claims PostgreSQL is the fastest data storage . “
The development of the modern state
Our community of members is constantly bringing new features to the product. Version 9.1 includes several new databases for the industry:
“OpenERP has always relied on the capabilities of the PostgreSQL industrial class to provide a fast, reliable and scalable foundation for business applications that supports our customers every day. Data integrity in a highly competitive business environment is an extremely important issue for us, and we are delighted with the new serial isolation of PostgreSQL 9.1 copies! ”Said Oliver Doni, head of OpenERP communities.
Expansion of the DBMS mechanism
PostgreSQL extensibility is what allows users to add new functionality to already running databases and use them to solve problems that no other DBMS can perform. Version 9.1 has several extension tools:
All of the above and many other innovations are described on the What's New in 9.1 wiki page and release notes .
For 25 years now, with each new annual release, the developer community has continued to improve database technology. Download version 9.1 and try the world's most advanced open source database.
More information about PostgreSQL 9.1:
Download version 9.1:
Based on PostgreSQL.org .
Information for users
Several features that users have been asking for over the years have been added to PostgreSQL 9.1, which eliminates obstacles in deploying new or ported applications to PostgreSQL. Among them:
')
- Synchronous Replication (Synchronous Replication): allows you to combine high availability with connectivity on multiple servers.
- Per-Column Collations: supports linguistically correct sorting in a database, table, or column.
- Unlogged Tables: Significant increase in performance with temporary data.
“Heroku provides the world's largest PostgreSQL database service as a service,” said James Lindenbaum, co-founder of Heroku, “Release of version 9.1 with synchronous data replication gives our customers the ability to protect critical information and claims PostgreSQL is the fastest data storage . “
The development of the modern state
Our community of members is constantly bringing new features to the product. Version 9.1 includes several new databases for the industry:
- K-Nearest-Neighbor Indexing: indexing on the fly for the fastest possible search and text search queries.
- Serial copyable isolation (Serializable Snapshot Isolation): the ability to store concurrent matched transactions without blocking, using “true orderability”.
- General rewritable table expressions (Writeable Common Table Expressions): the launch of a complex multi-step data update with a single query.
- Improved Security (Security-Enhanced Postgres): the launch of military-level security and mandatory access control.
“OpenERP has always relied on the capabilities of the PostgreSQL industrial class to provide a fast, reliable and scalable foundation for business applications that supports our customers every day. Data integrity in a highly competitive business environment is an extremely important issue for us, and we are delighted with the new serial isolation of PostgreSQL 9.1 copies! ”Said Oliver Doni, head of OpenERP communities.
Expansion of the DBMS mechanism
PostgreSQL extensibility is what allows users to add new functionality to already running databases and use them to solve problems that no other DBMS can perform. Version 9.1 has several extension tools:
- Foreign Data Wrappers: Attaching and querying information from other databases from PostgreSQL.
- Add-ons (Extensions): easy creation, loading and management of new database features.
All of the above and many other innovations are described on the What's New in 9.1 wiki page and release notes .
For 25 years now, with each new annual release, the developer community has continued to improve database technology. Download version 9.1 and try the world's most advanced open source database.
More information about PostgreSQL 9.1:
- Release Notes - Release Notes
- Press Release - Presskit
- Version 9.1 Guide - Guide to 9.1
Download version 9.1:
Based on PostgreSQL.org .
Source: https://habr.com/ru/post/128293/
All Articles