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: PostgreSQL

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

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