Swarm64 (swarm64.com) today announced the immediate availability of Swarm64 DA 5.0, which now enhances free, open source PostgreSQL with hybrid transactional/analytical processing (HTAP) capabilities. Swarm64 DA is turnkey software that extends free, open source PostgreSQL with much faster query performance to help customers lower costs, scale more easily, and simplify database application development.
Maintaining multiple copies of a database to support transactional systems of record and, separately, systems of insight, such as data warehouses, is a costly, decades-old practice. HTAP holds the promise of ending this duplication of resources, thus lowering database management costs, and simplifying operational analytics.
HTAP for PostgreSQL is made possible by the introduction of compressed columnstore indexing in Swarm64 DA 5.0 for PostgreSQL. Columnstore indexes enable very fast reporting and analysis on standard, transactional PostgreSQL database tables. This feature eliminates the cost of having to replicate data to a separate database for reporting, or having to analyze outdated data.
“HTAP is no longer the sole domain of expensive proprietary database software like Oracle, SAP HANA, and MemSQL,” said Thomas Ricther, CEO and co-founder of Swarm64. “Swarm64 DA 5.0 is an important breakthrough. It greatly simplifies database development for PostgreSQL users and gives enterprises a free, open source HTAP option in PostgreSQL.”
In addition to compressed columnstore indexing, Swarm64 DA 5.0 includes:
- Faster table scanning
- Support for PostgreSQL 12
- Support for EDB Postgres Advanced Server
- Acceleration of SQL
- Automatic update of table statistics
- Other query engine optimizations that simplify and extend Swarm64 DA’s acceleration of PostgreSQL SQL queries
Along with other PostgreSQL performance enhancements, like increased parallel processing, faster SQL JOIN functions, and several query engine improvements, Swarm64 DA 5.0 accelerates query performance 5x to 60x over standard PostgreSQL. Besides being an easy way to improve price-performance for PostgreSQL applications, Swarm64 DA also enables enterprises to replace expensive data warehouse databases with free, open source PostgreSQL, saving millions annually in IT costs.
Berlin-based Turbit Systems has been working with Swarm64 DA to meet the data management challenges of real-time condition monitoring of wind turbines.“We have been using Swarm64 DA for the past year to help us scale our machine learning platform for wind turbine performance,” said Michael Tegtmeier, CEO & Founder, Turbit Systems. “We are excited about Swarm64 DA 5.0 because, as with new versions before it, the Swarm64 team keeps making it easier for us to accelerate PostgreSQL database performance as our business grows.”
Pricing and availability
Swarm64 DA 5.0 is available immediately via the Swarm64 website or from the Amazon AWS Marketplace. Swarm64 DA 5.0 software is licensed on an annual subscription basis; a free Developer License is also available.
Swarm64 develops extensions to free open source PostgreSQL, one of the most widely used databases in the world. Swarm64 provides the easiest way for businesses to scale PostgreSQL query performance for enterprise systems. Swarm64 has built a world-class team of PostgreSQL database performance innovators, engineering new ways to accelerate PostgreSQL. It is backed by leading venture investors from the US, Norway, and Germany, and has offices in Berlin, Boston, and Palo Alto.