<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-text-html" lang="x-unicode"> PostgreSQL 9.4
rilasciato: <br>
<a class="moz-txt-link-freetext"
href="http://www.postgresql.org/about/news/1557/">http://www.postgresql.org/about/news/1557/</a><br>
<br>
18 DECEMBER 2014: The PostgreSQL Global Development Group
announces the release of PostgreSQL 9.4, the latest version of the
world's leading open source database system. This release adds
many new features which enhance PostgreSQL's flexibility,
scalability and performance for many different types of database
users, including improvements to JSON support, replication and
index performance.<br>
<br>
Flexibility<br>
<br>
With the new JSONB data type for PostgreSQL, users no longer have
to choose between relational and non-relational data stores: they
can have both at the same time. JSONB supports fast lookups and
simple expression search queries using Generalized Inverted
Indexes (GIN). Multiple new support functions enable users to
extract and manipulate JSON data, with a performance which matches
or surpasses the most popular document databases. With JSONB,
table data can be easily integrated with document data for a fully
integrated database environment.<br>
<br>
"JSONB brings PostgreSQL to the JavaScript development community
by allowing JSON data to be stored and queried natively. Node.js
and other server-side JavaScript frameworks can benefit from the
safety and robustness of PostgreSQL, while still storing data in
the schema-less format that they prefer," said Matt Soldo, Product
Manager, Heroku Postgres.<br>
<br>
Scalability<br>
<br>
In 9.4, Logical Decoding supplies a new API for reading, filtering
and manipulating the PostgreSQL replication stream. This interface
is the foundation for new replication tools, such as
Bi-Directional Replication, which supports the creation of
multi-master PostgreSQL clusters. Other improvements in the
replication system, such as replication slots and time-delayed
replicas, improve management and utility of replica servers.<br>
<br>
"The main reason behind our immediate adoption of PostgreSQL 9.4
in production is the new Logical Decoding feature," said Marco
Favale, Cartographic Production Manager of Navionics. "The ability
to write custom and flexible output plugins will allow us to
transparently collect changes on selected tables and replicate
changes where we like, by removing heavier - and more complex to
manage - trigger based replication solutions."<br>
<br>
"Zalando relies on the stability and performance of hundreds of
PostgreSQL database servers to continuously serve millions of
customers all around Europe," said Valentine Gogichashvili, Team
Lead Database Operations at Zalando Technologies. "We are excited
to run time-delayed standby servers which work out of the box, and
will evaluate the new bi-directional replication tools as soon as
they are released."<br>
<br>
Performance<br>
<br>
Version 9.4 also introduces multiple performance improvements
which will allow users to get even more out of each PostgreSQL
server. These include:<br>
<br>
Improvements to GIN indexes, making them up to 50% smaller and up
to 3X faster.<br>
Concurrently updatable Materialized Views for faster, more
up-to-date reporting.<br>
Rapidly reload the database cache on restart using pg_prewarm.<br>
Faster parallel writing to the PostgreSQL transaction log.<br>
Support for Linux Huge Pages for servers with large memory.<br>
"We will definitely benefit from concurrent refresh of
materialised views, delayed standby servers (which will make our
disaster recovery even more robust) as well as the usual
performance improvements every new release carries on," added
Marco Favale.<br>
<br>
Links<br>
<br>
Downloads<br>
Press Kit<br>
Release Notes<br>
What's New in 9.4<br>
About PostgreSQL<br>
<br>
PostgreSQL is the leading open source database system, with a
global community of thousands of users and contributors and dozens
of companies and organizations. The PostgreSQL Project builds on
over 25 years of engineering, starting at the University of
California, Berkeley, and has an unmatched pace of development
today. PostgreSQL's mature feature set not only matches top
proprietary database systems, but exceeds them in advanced
database features, extensibility, security and stability. Learn
more about PostgreSQL and participate in our community on our web
page.<br>
-- <br>
Hai ricevuto questo messaggio perché sei iscritto al gruppo
"Django-it" di Google Gruppi.<br>
Per annullare l'iscrizione a questo gruppo e non ricevere più le
sue email, invia un'email a <a
href="mailto:django-it+unsubscribe@googlegroups.com">django-it+unsubscribe@googlegroups.com</a>.<br>
Per postare in questo gruppo, invia un'email a <a
href="mailto:django-it@googlegroups.com">django-it@googlegroups.com</a>.<br>
Visita questo gruppo all'indirizzo <a
href="http://groups.google.com/group/django-it">http://groups.google.com/group/django-it</a>.<br>
Per altre opzioni visita <a
href="https://groups.google.com/d/optout">https://groups.google.com/d/optout</a>.<br>
</div>
</body>
</html>