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 ›

Swarm64 blog

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

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

Introducing the Swarm64 DA PostgreSQL Settings Advisor

Swarm64 DA 5.5 is released, and with it, we completed the development of the settings advisor. The settings advisor is a tool in the database that informs you in an explicit way which settings you should modify in your database and operating system to get great performance out of Swarm64 DA and PostgreSQL. First introduced […]

Read more

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