Category: How to

How to run Swarm64 DA with EDB Postgres Advanced Server
5-minute video shows how to install the Swarm64 DA extension into EDB Postgres Advanced to accelerate query performance

Unleash PostgreSQL Parallel Query
In this post, I want to show you how the Swarm64 DA PostgreSQL drop-in extension removes several limitations unleashing parallel query execution.

New open source Swarm64 HTAP Benchmark for PostgreSQL
Mixed (HTAP) workloads are challenging because they are either primarily OLTP (with some OLAP) or primarily OLAP (with some OLTP). Swarm64 developed a single benchmark to support both scenarios.

Modern data analysis with PostgreSQL – JSONB throws Window functions out the…
Taking a look at how transactional database features, such as fast UPDATEs and JSONB, can make analytics easier.

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.