Elephants are already here. Fast, reliable, powerful. PostgreSQL 8.3!

More than 200 developers, 300 patches the 15 months of hard work developers and testers... And here is the newest version of the best DBMS in the world ready to use in an industrial environment!

/ > 4 Feb 2008-year global development group PostgreSQL (PostgreSQL Global Development Group) announced the long-awaited release of version 8.3 of the most advanced open DBMS, a fact which further strengthens the position of the PostgreSQL as the most productive databases systems open source. Among the innovations on performance, it is necessary to highlight:

* HOT (Heap Only Tuples)
* the mechanism of autotune of parameters of process of bgwriter
* asynchronous commits (Asynchronous-Commit)
* "spread control points" (Spread Checkpoints)
* "sinhronizovani views" (Synchronous Scans)
* additional reduction of disk space ("Var-Varlena")
* protection of L2-cache
* reducing the speed of "speed cheating" transaction counter (Lazy XID)

PostgreSQL 8.3 also contains many interesting and attractive innovations that Dostoinstvo appreciated by developers and database administrators. Here are some of these innovations:

* CSV logging
* SQL/XML (!)
* support for MS Visual C++
* ENUM-types
* built-in Tsearch (!)
* SSPI &GSSAPI
* arrays of composite types
* pg_standby

This list is very short, this release contains many, many new. Look at the list of innovations and feature matrix, flip release, read article in Russian. And make sure to download and try!

The text of the official press release in Russian: www.postgresql.org/about/press/presskit83.html.ru
Article about new 8.3 in Russian: postgresmen.ru/articles/view/78
24/7 commercial support, advice on Russian language: postgresmen.ru
Article based on information from habrahabr.ru

Комментарии

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

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

Car navigation in detail

Изображение
This article is for those who are going in the near future to buy a car Navigator, but lacks information. For example, a typical Navigator Lexand Si-515 Pro HD I will try to elaborate what is now proposed on the market such devices. Also describe the impressions of three of the tested navigation systems, one of which passed in June, about three thousand kilometres through two countries. And at the end of the article will result in a large comparative table 23 current models of navigators Lexand, to show what can be possible in these devices. The choice of now is large enough. Prices and performance, thanks to competition, differ not so strongly. Typically, when buying are interested in the reliability and usability of the device. The functionality and relevance of the cards of 100% define the installed navigation system. It is therefore very important to be able to update it easily, and even better if you can run several different. the Characteristics and sp
Далее...

Google has launched an online training course advanced search

Изображение
/ > As planned Google today launched training the advanced search. I just received the e-mail. the text of the letter (in English) We're excited to launch the first class of Power Searching with Google! Get started by taking a pre-class assessment and studying the material in the first class: www.powersearchingwithgoogle.com Class 1 available Class 2 available July 11 Class 3 and mid-class assessment available July 12 Hangout on Air with search experts July 13 1:00-1:45pm PDT (add to calendar) Submit questions for search experts: www.google.com/moderator/#16/e=2004ad Mid-class assessment due July 17 at 7:59am PDT (add to calendar) Classes 4-6 available July 17-19 Hangout on Air with search experts July 19 11:00-11:45am PDT (add to calendar) Post-class assessment due July 23 at 4:59pm PDT (add to calendar) Need help? Please join the course staff in the course forum and follow our Google+ page for additional exercises, tips, and tricks!
Далее...

PostgreSQL: Analytics for DBA

Many users of PostgreSQL know that the server at the time of their work collects a variety of statistics, but not everyone knows that it is useful to analyze and how to extract it. This small Toolkit collected some useful queries that give some idea about how to use this "hidden knowledge", which constantly accumulates. These queries can be used to monitor the status of PostgreSQL (manually or with plugins for monitoring systems like Nagios, Cacti or Zabbix), to search for bottlenecks in the server and many other similar tasks. Remember that this is only the tip of the iceberg; in the documentation you can find descriptions of several dozen system ideas that can also be useful for the PostgreSQL administrator. For correct work need to enable Toolkit options stats_block_level and stats_row_level in postgresql.conf and set the parameter of stats_reset_on_server_start in its sole discretion. If each time you restart the PostgreSQL server you change some important configu
Далее...