Introduction to Swarm64 DA

Swarm64 DA accelerates analytical and hybrid analytical-transactional processing in PostgreSQL 11 and 12. By improving the planning, execution, and parallelism of queries it allows PostgreSQL to scale to larger datasets, more complex queries, and more users on the same system. Being an extension, Swarm64 DA easily supports new PostgreSQL releases so you can benefit from all the latest features.

Swarm64 DA and S64 DA are abbreviations of Swarm64 Data Accelerator.

When to use Swarm64 DA

Swarm64 DA accelerates workloads in the following cases:

  • Your dataset size is at least 100GB and it is larger than the amount of memory in the system.
  • You have problematic queries with an execution time of one second or more, that you would like to accelerate.
  • You have analytical queries that need to process large amounts of data.

How to obtain optimal benefits

Although Swarm64 DA may offer you an out-of-the-box speedup, you need to do the following in order to obtain maximum benefits for your particular workload: