Swarm64 blog

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.

Taking a look at how transactional database features, such as fast UPDATEs and JSONB, can make analytics easier.

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 […]

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

In this short video, I demonstrate how to install the Swarm64 DA extension into an existing PostgreSQL database.

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.

In this short video, I demonstrate how to install the Swarm64 DA extension into an existing PostgreSQL database.

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.

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? […]

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.