A recent press release reports, “Swarm64 (swarm64.com), the leader in database acceleration solutions for the PostgreSQL open source database, today announced the availability of Swarm64 DA 4.0, database acceleration software that extends PostgreSQL with the ability to analyze data orders of magnitude faster than usual, even as data streams into the database. This enables more people to choose free open source PostgreSQL over costly proprietary databases for new analytic and data warehouse modernization projects.”
Thomas Richter, CEO and co-founder of Swarm64, commented, “PostgreSQL is immensely popular and battle-hardened as a primary database, yet, for performance reasons it’s historically less popular in data warehousing and analytics. We’re on a mission to change that… Now, when extended with the Swarm64 DA accelerator, PostgreSQL runs orders of magnitude faster because we’ve tripled the acceleration effects in release 4.0. This enables people to cut database costs by 75% or more by using free, open source PostgreSQL in a greater number of projects and meet performance requirements that until now, only costly, proprietary data warehouse and analytic databases could satisfy.”
The release adds, “Swarm64 is the easiest way to accelerate and scale PostgreSQL performance. It installs as an extension to free, open source PostgreSQL and does not require changes to a user’s SQL or application code. New features of Swarm64 DA include: (1) Greater Parallel processing. The Swarm64 DA extension rewrites query patterns that execute in parallel at every phase of the query. It parallelizes scanning, filtering, joining, and merging, and spins up to 64 parallel threads. (2) Accelerated SQL Joins. JOIN conditions are widely used in SQL queries, but they are notoriously slow to process. With join acceleration in release 4.0, PostgreSQL can answer a wider variety of queries, which had heretofore been prohibitively slow for most users.”
Read more at Business Wire.
Image used under license from Shutterstock.com