Category: How to

Compression & PostgreSQL columnstore indexes

PostgreSQL columnstore indexes have a compression setting. Learn the pros and cons of different compression settings to help you tune performance better.

Read more

Introduction to PostgreSQL Columnstore Indexing

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

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

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
FPGA Postgres reference architecture

Scaling inside with Swarm64 and Intel FPGA at Strata NYC

Swarm64 is at Strata NYC this week! Come see our reference architecture for real-time market analytics at scale. Swarm64, Postgres, FPGA

Read more

Scaling an elastic PostgreSQL cluster using foreign data wrappers

How to set up an elastic cluster with parallel query execution using freely available open-source components from the PostgreSQL ecosystem.

Read more