Swarm64 blog

Welcome to the Swarm64 blog. We hope you enjoy the PostgreSQL performance advice and news we share here!

Introduction to PostgreSQL Columnstore Indexing

Learn how Columnstore Indexes in Swarm64 DA 5.0 speed up PostgreSQL query performance.

Read more

Announcing Swarm64’s partnership with Command Prompt, Inc.

Swarm64 & Command Prompt, Inc. are partnering to expand the use of free, open source PostgreSQL for data warehousing and analytics.

Read more

Powering up Postgres for Open Source Data Warehousing & Analytics

CEO Thomas Richter is interviewed on the Data Engineering Podcast and explains how PostgreSQL is evolving to support analytics & reporting at scale

Read more

Will Swarm64 DA speed up my PostgreSQL database?

Swarm64 DA speeds up some PostgreSQL queries more than others. “Will Swarm64 DA speed up your database?” This post dives into scenarios that are good candidates for Swarm64 DA acceleration.

Read more

PostgreSQL parallelism can be like a box of chocolates (you never know what you’re going to get)

It can be challenging to predict how PostgreSQL parallelism will affect a query. In this post, we recommend ways to speed up queries thru better parallelism.

Read more

Announcing Swarm64 DA 4.0

Today, I am happy to announce the release of Swarm64 DA 4.0, database acceleration extensions for Postgres. Highlights include 3x more query acceleration and now you can use Swarm64 DA with–or without–FPGA.

Read more

Backup and restore data in PostgreSQL foreign tables using pg_dump

A recent Swarm64 contribution to PostgreSQL 13 that enables pg_dump to more fully support the backup and restoration of foreign tables.

Read more
Amazon EC2 F1 instance icon

Provision Postgres on an FPGA-accelerated AWS F1 instance in 5 minutes

Want to lower data platform costs for analytic or query-intensive projects? Consider free, open source Postgres on an FPGA-accelerated AWS F1 instance for great price-performance. Here’s how to do it…

Read more
hardware acceleration for postgres 2020

3 hardware acceleration options Postgres users should know in 2020

The three hardware acceleration options that we believe will have the most immediate impact on Postgres users in 2020. FPGA, Intel Optane, Samsung SmartSSD.

Read more
xilinx invests in swarm64

Swarm64 raises fresh capital to accelerate growth from FPGA inventor Xilinx

Xilinx, Inc. has invested in Swarm64 and will work together to deliver high-performance analytic databases to market.

Read more