Latest News
Video: Installing the Swarm64 DA extension into an existing PostgreSQL database Read more ›
Webinar (May 6th, 10 am PST): Faster PostgreSQL query performance on Amazon with PG Nitrous Register here ›

Swarm64 blog

Welcome to the Swarm64 blog. We hope you enjoy the PostgreSQL performance advice and news we share here!

Swarm64 & EDB partner to extend Postgres with faster queries

Swarm64 & EDB are teaming up to offer an alternative to costly legacy data warehouse databases.

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

Improving columnstore and btree index cooperation in Swarm64 DA 5.4.0

We’re happy to announce that Swarm64 DA 5.2 has been released, which comes with several improvements to make deployment easier and more flexible.

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

Improving RDS PostgreSQL application query price-performance 25x with PG Nitrous

In this post, we detail the query price-performance advantages of PG Nitrous by comparing TPC-H benchmark results for Amazon RDS and PG Nitrous.

Read more

New: Parallel processing of cursors in PostgreSQL for faster BI tool performance.

Late last year, a Swarm64 DA user told to us: “When I execute my query via the psql client it returns in a couple of seconds, but if I execute it via DataGrip it never finishes.”   Have you also experienced different query performance using the psql client vs. a business intelligence (BI) or reporting tool? […]

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

Announcing PG Nitrous 6.0

I’m pleased to announce that Swarm64 has released version 6.0 of the PG Nitrous PostgreSQL cloud database. It’s now easier than ever to launch and configure PG Nitrous with optimal AWS cloud infrastructure for your workload.

Read more

Announcing Swarm64 DA 5.2

We’re happy to announce that Swarm64 DA 5.2 has been released, which comes with several improvements to make deployment easier and more flexible.

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