Released PostgreSQL 9.1

"Among all DBMS open source PostgreSQL 9.1 provides some of the most advanced industrial capabilities and supported by an energetic and innovative community with proven success in consumer. PostgreSQL — proven solution for installing and running applications in the cloud," said Charles Fan, senior Vice President of the Department of research and development, VMware.

/ > user Information

Several functions, the implementation of which users have requested over the years, were added in PostgreSQL 9.1 that allows you to get rid of the obstacles to deploying new or ported applications on PostgreSQL. Among them:

the
    the
  • Synchronous replication (Synchronous Replication): allows you to combine high availability with connectivity to multiple servers.
    • the
  • a Comparison of column (Per-Column Collations): support linguistically-correct sorting in the database, table or column.
    • the
  • Busprotocol table (Unlogged Tables): a significant increase in productivity with real-time data.



"Heroku provides the world's largest database service PostgreSQL as services," said James Lindenbaum, Heroku co-founder, "the Release of version 9.1 with synchronous data replication gives our customers the possibility of new methods to protect critical information and argues for PostgreSQL, the status of the rapid data warehouse."

the Development of the modern state

Our community of users is constantly contributing to new product opportunities. Version 9.1 includes several new to industry databases:

the
    the
  • the index of the nearest neighboring records (K-Nearest-Neighbor Indexing): indexing on the fly for faster location and text-search queries.
    • the
  • Serial isolation copies (Serializable Snapshot Isolation): the ability to store competing the agreed transaction without blocking, using "true uporyadochennost".
    • the
  • Shared writable expression of the table (Writeable Common Table Expressions): run a single query complex multi-stage data updates.
    • the
  • Improved security (Security-Enhanced Postgres): starting military security levels and mandatory access control.


"OpenERP has always relied on the possibility of industrial-class PostgreSQL to provide a fast, reliable and scalable Foundation for business applications that support the actions of our customers every day. Data integrity in a highly competitive business environment for us is a very important question, and we are delighted with the new serial isolation copies of "PostgreSQL 9.1"!" said Oliver Downey, head of the community of OpenERP.

Extension mechanism DBMSs

PostgreSQL's extensibility — this allows users to add new functionality to already running databases and use them to solve tasks that can not perform any other DBMS. Version 9.1 has several tools extensions:

the
    the
  • Wrapper foreign data (Foreign Data Wrappers): attach and query other databases from PostgreSQL.
    • the
  • add-Ons (Extensions): easily create, load and manage new features of the database.


All of the above and many other innovations described on the wiki page "What's new in 9.1" (What's New in 9.1) and the release notes (release notes).

For 25 years, with each new annual release, the developer community continues to improve the technology of databases. Download version 9.1 and try the most developed in the world of DBMS with the open source community.

More information on PostgreSQL 9.1:
the
Article based on information from habrahabr.ru

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Vkontakte sync with address book for iPhone. How it was done

Изображение
the Background application on androidphone when you install the application Vkontakte is possible to use it as a provider of contacts to synchronize the contacts from Facebook with contacts in your address book. In this case stretches the avatar, date of birth, address, phone numbers, etc. When I after prolonged use HTC Wildfire S rated and are so used to this that he wanted to find a similar to the iPhone. Not found, so we took it and made his own — Synchronizer VKontakte :) It was back in November of last year. The application was done fairly quickly — it uses quite a few functions of Vkontakte API and functionality with the address book of the iPhone. But when we started to deal with the automatic matching of contacts, it was fun. Compare head-on by name, last name and phone number was easy to do, easy, and worked through it quickly. But found only 20 percent of coincidences of the contacts from what is provider in Android. Of course, only direct hits do not sui
Далее...

Automatically create Liquibase migrations for PostgreSQL

Изображение
Working with Liquibase always brings confidence in the fact that the database objects are in the same condition in which you want it. It is this confidence and makes system migrations so popular databases. Today I want to tell you how to make using liquibase a bit easier. If you write a migration by hand, and your target database is PostgreSQL, then read this article, I am sure, the time spent on reading the article will be repaid with interest. I hope you already know how to work with Liquibase, so only two words describe how the system works. In order to make changes in the database, you need to create a migration file (changeset) that you need to specify in the file change log (changelog), after which the migration can be successfully applied to the target database. Undeniable and obvious benefit of this approach is the ability to rollback the changes. In my opinion, liquibase, there is only one drawback — the automatic rollback of changes only works only if the mi
Далее...

What part of the archived web

Изображение
/ > the time Machine Internet Archive is the largest and well-known archive that preserves web pages since 1995. Besides him there are a dozen other services, which are also archived to the web: the indexes of search engines and industry-specific archives like Archive-It , UK Web Archive , Cite Web , ArchiefWeb , Diigo . Interesting to know how many web pages gets into these files, relative to the total number of documents in the Internet? It is known that the base of the Internet Archive for 2011 contains more than 2.7 billion URIs , many of them in multiple copies taken at different points in time. For example, the home page of Habra "photographed" already 518 times since July 3, 2006 . It is also known that the base reference Google five years ago overstepped the mark in trillion unique URLS , although many of the documents were duplicated. Google is not able to perform all URLS, so the company decided to count the number of documents in the Internet a
Далее...