Swarm64 DA accelerates PostgreSQL query performance 20x


PostgreSQL extension

Swarm64 DA extends free, open source PostgreSQL. Not a fork and no migrations or SQL or coding changes required.

Greater parallelism

5x more parallel workers per query, and queries execute in parallel at every phase, from scanning & filtering, thru joining, sorting, & aggregating.

Columnar storage

Define compressed columnstore indexes on any PostgreSQL table to dramatically reduce I/O and speed up queries.

Improved query planning

Enriches PostgreSQL with better cost statistics and query plans for faster queries without changing your SQL semantics.

Faster SQL JOINs

Special hash join algorithm runs 3x faster, and use 50% less memory. Join-billion row tables in seconds.

Deployment flexibility

Swarm64 DA accelerates PostgreSQL v11 and higher, on-premises or on the cloud. Run it on any hardware that PostgreSQL supports.

Swarm64 DA use cases

Data warehousing and analytics

  • Migrate data warehouse workloads off of expensive, proprietary legacy platforms, and on to Swarm64 DA-accelerated PostgreSQL
  • Reduce IT data warehousing costs by 60% to 90%
  • State of the art analytic database functionality – parallel query processing, columnstore indexing, fast JOINs, and more
  • Works with all PostgreSQL-compatible tooling, BI, ETL
Swarm64 DA for data warehousing (.pdf)

Scaling SaaS reporting & analytics

  • Accelerate PostgreSQL-based reporting and analytics dashboards
  • Support 3x to 5x more concurrent users with each accelerated server = scaling with fewer servers and lower cloud costs
  • Less variance in query performance as you scale
White paper: Scaling PostGIS at Toyota

Machine learning & time series

  • Run machine learning algorithms at scale
  • Analyze larger data sets
  • Query performance on data streaming into PostgreSQL
  • Faster machine learning testing & iteration
Swarm64 DA for IoT (.pdf)

Try Swarm64 DA or learn more…

Request a Swarm64 demo