Citus Data Releases New Version of CitusDB 4.0 for Hybrid Transaction/Analytical Processing on PostgreSQL 9.4
pg_shard 1.1 and cstore_fdw 1.2 Open Source Extensions Also Released
(firmenpresse) - SAN FRANCISCO, CA -- (Marketwired) -- 03/26/15 -- , creators of solutions to scale out and extend the analytics capabilities of PostgreSQL, today announced the general availability of CitusDB 4.0, the latest release of the company's hybrid transaction/analytical processing platform for massively scalable, high availability PostgreSQL. CitusDB 4.0, based on the latest PostgreSQL 9.4 release, enables companies to massively scale out PostgreSQL across commodity servers and use parallel processing to distribute queries across the cluster for real-time analytics queries on big data. The CitusDB 4.0 release improves performance and usability while migrating to the PostgreSQL 9.4 platform, which provides greatly enhanced support for unstructured data types. In conjunction with the release of CitusDB 4.0, Citus Data released new versions of the company's open source projects, pg_shard, and cstore_fdw.
The advanced platform powers hybrid transaction/analytical processing across hundreds of billions of events while cutting query times by up to 100x. By moving to PostgreSQL 9.4, the platform now provides enhanced support for both structured and unstructured data through JSONB. CitusDB 4.0 brings exciting new functionality and performance improvements, including:
CitusDB Enterprise Edition now integrates with pg_shard to support real-time workloads. This integration combines scalable analytics and low-latency writes in a single system.
New features include JSONB support, a faster, more efficient data type for storing JSON data, faster and smaller GIN indexes, and .
Users can incrementally add nodes and uniformly distribute data, and thus traffic, to those nodes. Users can also re-replicate data from failed nodes evenly across all the remaining nodes.
A new task-assignment policy provides better in-memory workload performance, while binary serialization for data copied between nodes provides faster performance on queries fetching a lot of data. Batching task-assignment calls improves performance with re-partition joins.
Modified STAGE allows loading data from any node in the cluster, making data-loads much easier and allowing for a more uniform data placement. Query throttling in the real-time executor prevents resource exhaustion when queries touch thousands of shards.
is an open source extension for transparently scaling out PostgreSQL horizontally across commodity servers. pg_shard automatically shards Postgres tables and replicates the shards on multiple nodes in the cluster, ensuring high availability for PostgreSQL databases. Updates in the current release include:
The INSERT commands run up to four times faster.
Inactive placements can be easily brought back up to speed.
Data from .csv and other files can be quickly imported from the command line.
pg_shard's metadata can now be exposed for use by CitusDB.
Larger queries can be executed.
pg_shard 1.1 can be downloaded from GitHub at .
(PostgreSQL Columnar Store Extension) is an open source extension for creating columnar PostgreSQL tables, which can reduce query times as well as storage footprint. Updates in the current release include:
Data can now be loaded directly into cstore from regular PostgreSQL tables.
The COPY command can now be used to copy the contents of a cstore table to a file.
As much as 90 percent less memory is used in some scenarios.
cstore_fdw 1.2 can be downloaded from GitHub at .
"The Citus Data product family of CitusDB, pg_shard, and cstore_fdw allow companies to use PostgreSQL to tackle large datasets and big data analytics challenges. Whether companies are facing scaling issues, need to reduce query times and storage footprint, or want to simplify their transaction and analytical database infrastructure, Citus Data products provide powerful solutions. We are excited about the release of CitusDB 4.0 which now seamlessly integrates with pg_shard on PostgreSQL 9.4 to deliver a very powerful solution for companies that want to slash the cost and complexity of their database infrastructure by implementing a single database for both their transaction and analytical processing."
Citus Data offers solutions which power massively scalable PostgreSQL for real-time applications. The hybrid transaction/analytical processing platform powers real-time workloads across hundreds of billions of events while cutting query times up to 100x and supporting both structured and JSON data. Citus Data also offers , an open source extension for scaling out PostgreSQL across commodity servers, and , an open source extension for creating columnar PostgreSQL tables. Citus Data is a Y Combinator alumnus, and is backed by investors that include Data Collective, Bullpen Capital and SV Angel. All Citus Data products are available for download at .
Terry Erisman
Citus Data
(415) 688-4093
Themen in dieser Pressemitteilung:
Unternehmensinformation / Kurzprofil:
Datum: 26.03.2015 - 13:18 Uhr
Sprache: Deutsch
News-ID 381356
Anzahl Zeichen: 0
contact information:
Town:
SAN FRANCISCO, CA
Kategorie:
Diese Pressemitteilung wurde bisher 252 mal aufgerufen.
Die Pressemitteilung mit dem Titel:
"Citus Data Releases New Version of CitusDB 4.0 for Hybrid Transaction/Analytical Processing on PostgreSQL 9.4"
steht unter der journalistisch-redaktionellen Verantwortung von
Citus Data (Nachricht senden)
Beachten Sie bitte die weiteren Informationen zum Haftungsauschluß (gemäß TMG - TeleMedianGesetz) und dem Datenschutz (gemäß der DSGVO).
