Introduction to PostgreSQL Columnstore Indexing
Learn how Columnstore Indexes in Swarm64 DA 5.0 speed up PostgreSQL query performance.
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
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.
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.
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.
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.