NoSQL开源数据库PostgreSQL宣布了v9.2版

PostgreSQL是平等种有名的开源数据库。目前PostgreSQL全球开发小组发表了新式的9.2版本,对性做出了庞大提高,并追加了针对性JSON的内建补助。

早于当年仲夏发表beta版的早晚,该小组的上位数据工程师Ines
Sombra就做出承诺:

PostgreSQL
9.2会晤包含本地的JSON帮助,新特性涉及到目、复制与总体性进步等大多地点。

PostgreSQL
9.2支撑水平扩大及64独核心,可以举行单独针对索引(index-only)的围观,并降低对CPU电力的淘,从而显然改进了多数干活负荷下之可伸缩性和开发者的八面玲珑;在笔直可伸缩性方面的精益求精为PostgreSQL可以更实用地运大型服务器上之硬件资源,在沿管理、写副功能、仅针对索引的拜会和其他小级别之操作让数据库引擎能够处理又大气底干活负荷。

这么些性及的革新体现于数字上象征:

  • 每秒最多350,000不良读取查询(快了4加倍多)
  • 针对数据仓库查询的只有对索引的围观(快了2-20倍)
  • 每秒最多14,000次等数据写入

此外,PostgreSQL
9.2还受开发的八面玲珑做出了再次进一步的支撑,它包含了针对Range类型和JSON的支撑,让开发者可以以全两样的法来行使PostgreSQL。

Range类型让开发者可以制造更好的与日历相关、科学和财务的应用程序。还尚未外主流数据库帮忙这种特点;在PostgreSQL中,查询结果可知以JSON数据类型的格式重回。用户可以把这种技能以及PL/V8
Javascript和PL/Coffee数据库编程扩大以及可选的HStore
key-value数据库组合在一起,把其看成“NoSQL”文档数据库来选择,同时还保存了PostgreSQL的可靠性、灵活性和总体性及之优势。

 

The PostgreSQL Global Development Group announces PostgreSQL 9.2, the
latest release of the leader in open source databases. Since the beta
release was announced in May, developers and vendors have praised it as
a leap forward in performance, scalability and flexibility. Users are
expected to switch to this version in record numbers.

“PostgreSQL 9.2 will ship with native JSON support, covering indexes,
replication and performance improvements, and many more features. We
are eagerly awaiting this release and will make it available in Early
Access as soon as it’s released by the PostgreSQL community,” said
Ines Sombra, Lead Data Engineer, Engine Yard.

Links

Improved Performance and Scalability

With the addition of linear scalability to 64 cores, index-only scans
and reductions in CPU power consumption, PostgreSQL 9.2 has
significantly improved scalability and developer flexibility for the
most demanding workloads. Organizations like the U.S. Federal Aviation
Administration and Heroku.com run applications on PostgreSQL, and HP has
adopted it for their remote support software and to power their
HP-UX/Itanium solutions.

Improvements in vertical scalability increase PostgreSQL’s ability to
efficiently utilize hardware resources on larger servers. Advances in
lock management, write efficiency, index-only access and other low-level
operations allow the database engine to handle even larger-volume
workloads.

Numerically, this means:

  • Up to 350,000 read queries per second (more than 4X faster)
  • Index-only scans for data warehousing queries (2–20X faster)
  • Up to 14,000 data writes per second (5X faster)

Also, the addition of cascading replication enables users to run even
larger stacks of horizontally scaled servers under PostgreSQL 9.2.

“NewsBlur, a social news reader, relies on Postgres for storing
millions of sites and subscriptions. Solid and reliable for years,”
said Samuel Clay, founder of newsblur.com. “We’re consistently on the
bleeding edge (9.1 now, moving to 9.2 soon for the cascading
replication alone) and it’s been a pleasure since 8.4.”

Flexible Developer Support

The flexibility of PostgreSQL is reflected in the diversity of
organisations that have adopted it. For example NASA, the Chicago
Mercantile Exchange and Instagram all rely on it to perform
mission-critical applications. Version 9.2 extends this flexibility even
further by including support for Range Types and JSON, allowing
developers to use PostgreSQL in completely new ways.

Range Types allow developers to create better calendaring, scientific,
and financial applications. No other major SQL database supports this
feature, which enables intelligent handling of blocks of time and
numbers.

With PostgreSQL 9.2, query results can be returned as JSON data types.
Combined with the new PL/V8 Javascript and PL/Coffee database
programming extensions, and the optional HStore key-value store, users
can now utilize PostgreSQL like a “NoSQL” document database, while
retaining PostgreSQL’s reliability, flexibility and performance.

“Native JSON support in PostgresSQL provides an efficient mechanism
for creating and storing documents for web APIs. We use front-end
libraries like jQuery to request tabular and tree-structured data; and
the new features make it convenient and provide performance advantages
in retrieving that data as JSON, ” said Taras Mitran, Senior
Architect, IVC Inc.

相关著作:

PostgreSQL
9.2已公布

网站地图xml地图