Category: How to

Video: Increasing PostgreSQL parallel query execution with Swarm64
In this short video, I demonstrate how to install the Swarm64 DA extension into an existing PostgreSQL database.

Video: Installing the Swarm64 DA extension into an existing PostgreSQL database
In this short video, I demonstrate how to install the Swarm64 DA extension into an existing PostgreSQL database.

Video: Swarm64 DA Columnstore indexes explained
Are you in index “hell?” With typical B-tree indexes, you must guess which columns will be selected by your queries most of the time. If you index too few columns, your queries will be slow. If you index too many, you will pay a performance penalty maintaining all the indexes.

Using PG Nitrous as a fast read replica for Amazon RDS PostgreSQL
Here is a step-by-step guide on how to set up a PG Nitrous database as a read replica for your Amazon RDS (Postgres) database.

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.

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

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.

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.

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.

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…