IT Blog, IT News,

PostgreSQL 9.2 released

2 m read
QArea Expert
QArea Expert Marketing Manager
September 13, 2012
Share on
Reading Time: 2 minutes

On September 10, 2012 the PostgreSQL Global Development Group officially announced PostgreSQL 9.2 release!

Finally the long period of beta testing declared in May of this year was completed. Developers promise the improved performance, scalability and flexibility.

The improved performance and scalability

Now Postgres supports 64-nuclear processors and its energy use was decreased. Everything is clear and without superfluous retreats.

The index-only scan mechanism is realized. The matter is that Postgres’s indexes don’t contain any information about visibility of record. Thus to understand if the record is visible the server needs to read a real tabular tuple. There is a situation that the index contains information about out-of-date tuple. The access to the sorted index is much faster than access to the real table. There is no information about visibility of record but developers realized so-called “visibility map”. But the visibility map has been created earlier. In the new release it was made steady against server falling as well as guaranteed correct. Also Streaming Replicatio is improved and polished.

There was created a JSON type parent support. The server checks a validity of entering data and shows defects. It also contains a full set of functions for converting in JSON.

And the greatest feature became the support of Range Types:

  • Ranges can be both discrete and continuous. The discrete types are int4range, int8range and date4range. The continuous types are numrange, tsrange, tstzrange (ts — timestamp, num — numeric).
  • The range can be opened. Probably you know about round and square brackets: [1; 1] — closed, and [1; 1) — opened in the right side etc.
  • The infinity (∞) can be border of a range!

Earlier this feature we had to use two fields for storage of such data. And now we have operators, indexes and constraints.

Such comparative numbers with the last versions are given in the official text:

  • About 350000 requests for reading per second (faster in 4 times);
  • Index-only scannin can give a gain in speed from 2 to 20 times;
  • About 14000 data trackers per second.

Tags
    Share on
    Privacy Preference Center
    Your Privacy

    When you visit any web site, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

    Strictly Necessary Cookies Always Active

    These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.

    You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.

    Performance Cookies

    These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

    All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.

    Cookies used

    Google Analytics
    Functional Cookies

    When you visit any web site, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

    Cookies used

    Test Second Test
    Targeting Cookies

    When you visit any web site, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

    More Information

    When you visit any web site, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.