Latest News
Start your free PG Nitrous Trial Get started ›
Swarm64 & EDB partner to extend Postgres with faster queries Read more ›
Blog Post: Introducing the Swarm64 DA PostgreSQL Settings Advisor Read more ›

Category: How to

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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