Swarm64 DA extends free, open source PostgreSQL. Not a fork and no migrations or SQL or coding changes required.
5x more parallel workers per query, and queries execute in parallel at every phase, from scanning & filtering, thru joining, sorting, & aggregating.
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.
Swarm64 DA accelerates PostgreSQL v11 and higher, on-premises or on the cloud. Run it on any hardware that PostgreSQL supports.
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
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
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